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

Re: PG 9.1 regression / row comparison?

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: ddebernardy(at)yahoo(dot)com
Cc: pgsql-testers(at)postgresql(dot)org
Subject: Re: PG 9.1 regression / row comparison?
Date: 2011-06-15 02:40:32
Message-ID: 4DF81BA0.3000601@archidevsys.co.nz (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

Responses

pgsql-bugs by date

Next:From: Perry SmithDate: 2011-06-15 02:50:44
Subject: BUG #6059: Out of tree build fails using Make 3.82
Previous:From: Alvaro HerreraDate: 2011-06-14 19:47:59
Subject: Re: BUG #6057: regexp_replace & back references

pgsql-testers by date

Next:From: Denis de BernardyDate: 2011-06-15 21:07:29
Subject: Re: PG 9.1 regression / row comparison?
Previous:From: Denis de BernardyDate: 2011-06-08 14:52:19
Subject: PG 9.1 regression / row comparison?

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