postgres distinct on returning half strings code example Example: psql select unique SELECT DISTINCT column1 FROM table_name;