MySQL will grab the unique values for the first column. PostgreSQL lets you define a set of columns for DISTINCT queries, defaulting to ALL columns. In Views, PostgreSQL DISTINCT should explicitly grab distinct NIDs, UIDs, TIDs, or other entity IDs.