I've actually traced it down to btree_gist. Not sure if this is the expected behavior:
test =# select row(1,2) <> row(1,2);
ERROR: could not determine interpretation of row comparison operator <>
LINE 1: select row(1,2) <> row(1,2);
^
HINT: Row comparison operators must be associated with btree operator families.
test=# drop extension btree_gist cascade;
NOTICE: drop cascades to constraint test_period_excl on table test.test_revs
DROP EXTENSION
test =# select row(1,2) <> row(1,2);
?column?
----------
f
(1 row)
From: Gavin Flower <GavinFlower@archidevsys.co.nz> To: ddebernardy@yahoo.com Cc: pgsql-testers@postgresql.org Sent: Wednesday, June 15, 2011 4:40 AM Subject: Re: [TESTERS] PG 9.1 regression / row comparison?
[...] > test=# select row(1,2) <> row(1,2); > > ERROR: could not determine interpretation of row comparison operator <> > LINE 1: select row(1,2) <> row(1,2); > ^ > HINT: Row comparison operators must be associated with btree operator > families.
Hi Denis,
I don't get this error with 9.1beta2,
$ uname -a Linux saturn 2.6.35.13-92.fc14.x86_64 #1 SMP Sat May 21 17:26:25 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux $ psql psql (9.1beta2) Type "help" for help.
gavin=> select row(1,2) <> row(1,2); ?column? ---------- f (1 row)
Cheers, Gavin - HOWTO Alpha/Beta Test: http://wiki.postgresql.org/wiki/HowToBetaTest To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-testers