PostgreSQL: Can't use DISTINCT for some data types
Hi, I have a table called _sample_table_delme_data_files which contains some duplicates. I want to copy its records, without duplicates, into data_files: INSERT INTO data_files (SELECT distinct * FROM _sample_table_delme_data_files); ERROR: could not identify an ordering operator for type box3d HINT: Use an explicit ordering operator...