Re: PG 9.1 regression / row comparison? - Mailing list pgsql-testers

From Gavin Flower
Subject Re: PG 9.1 regression / row comparison?
Date
Msg-id 4DF81BA0.3000601@archidevsys.co.nz
Whole thread Raw
In response to PG 9.1 regression / row comparison?  (Denis de Bernardy <ddebernardy@yahoo.com>)
Responses Re: PG 9.1 regression / row comparison?
List pgsql-testers
[...]
 > 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

pgsql-testers by date:

Previous
From: Denis de Bernardy
Date:
Subject: PG 9.1 regression / row comparison?
Next
From: Denis de Bernardy
Date:
Subject: Re: PG 9.1 regression / row comparison?