PG 9.1 regression / row comparison?

From: Denis de Bernardy <ddebernardy(at)yahoo(dot)com>
To: "pgsql-testers(at)postgresql(dot)org" <pgsql-testers(at)postgresql(dot)org>
Subject: PG 9.1 regression / row comparison?
Date: 2011-06-08 14:52:19
Message-ID: 537229.49593.qm@web112417.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-testers

I seem to remember that each of the following three statements worked in PG 9.0. Is the last one failing expected in 9.1? Or is it due to the various contrib modules I've been playing with? (I've installed btree_gin, btree_gist, semver, temporal, pgcrypt, spi/timetravel, and a couple more I can't remember off the top of my head...)

test=# select row(1,2) = row(1,2); -- returns t
test=# select row(1,2) is distinct from row(1,2); -- returns f

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.

Browse pgsql-testers by date

  From Date Subject
Next Message Gavin Flower 2011-06-15 02:40:32 Re: PG 9.1 regression / row comparison?
Previous Message Greg Smith 2011-05-24 17:03:13 Re: 9.1Beta1 - Repeatable Crash on Windows