Are Postgres SELECT DISTINCT queries deterministic? Will SELECT DISTINCT somecolumn FROM sometable return the same result (including order) if the table (and entire database) goes unchanged? In the Select Query Documentation the Description section notes: If the ORDER BY clause is specified, the returned rows are sorted in the specified order. If ORDER BY is not given, the rows are