pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PG 9.1 regression / row comparison?
3+ messages / 2 participants
[nested] [flat]

* PG 9.1 regression / row comparison?
@ 2011-06-08 14:52  Denis de Bernardy <ddebernardy@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Denis de Bernardy @ 2011-06-08 14:52 UTC (permalink / raw)
  To: 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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PG 9.1 regression / row comparison?
@ 2011-06-15 02:40  Gavin Flower <GavinFlower@archidevsys.co.nz>
  0 siblings, 1 reply; 3+ messages in thread

From: Gavin Flower @ 2011-06-15 02:40 UTC (permalink / raw)
  To: ddebernardy@yahoo.com; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PG 9.1 regression / row comparison?
@ 2011-06-15 21:07  Denis de Bernardy <ddebernardy@yahoo.com>
  parent: Gavin Flower <GavinFlower@archidevsys.co.nz>
  0 siblings, 0 replies; 3+ messages in thread

From: Denis de Bernardy @ 2011-06-15 21:07 UTC (permalink / raw)
  To: pgsql-testers

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
>
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2011-06-15 21:07 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-08 14:52 PG 9.1 regression / row comparison? Denis de Bernardy <ddebernardy@yahoo.com>
2011-06-15 02:40 Re: PG 9.1 regression / row comparison? Gavin Flower <GavinFlower@archidevsys.co.nz>
2011-06-15 21:07 ` Denis de Bernardy <ddebernardy@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox