On Sat, Apr 26, 2014 at 6:39 PM, Atri Sharma <atri.j...@gmail.com> wrote: > Without sorting, isnt the scope of a recursive UNION with custom datatypes > pretty restrictive?
All the default data types are hashable. It's not hard to add a hash operator class. In a clean slate design it would probably have been simpler to just make it a requirement that any data type provide a default hash operator (and probably a default btree comparator). Postgres provides a lot of degrees of freedom but it should probably be considered best practice to just provide both even if you don't envision one or the other being used directly by users for indexes. -- greg -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers