On Sun, Jan 18, 2009 at 2:52 AM, Tom Lane <[email protected]> wrote: > "Brendan Jurd" <[email protected]> writes: >> Update. Turns out that 8.4 DOES know how to execute the view. If you >> try to group on a user-defined composite type, 8.4 just goes ahead and >> groups it, rather than giving the old "could not identify an ordering >> operator" error. > > Is there a hash opclass for the type? 8.4 can group types that have > hash but not btree opclasses, but prior versions insisted on btree.
Well I sure didn't create one. I've only been attempting to create a btree opclass. Is there some kind of default hash opclass for composites? Cheers, BJ -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
