Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-testers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group