Viktor Rosenfeld <listuse...@googlemail.com> writes: > this looks good, but it does not work with DISTINCT.
> CREATE TYPE annotation AS ( namespace varchar, name varchar, value varchar > ); > ERROR: could not identify an equality operator for type annotation My recollection is you need a complete btree operator class to support DISTINCT. 8.4 would provide that automatically for composite types, but in 8.3 you'll have to build it yourself. > I've also tried [ a hash opclass ] > But then the error message changes to: > ERROR: cache lookup failed for operator 34755 That's not what I get when I copy your example, so I think you left something out. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general