pg.ddx.io pgsql-testers@postgresql.org mailing list archive
help / color / mirror / Atom feedPG 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>
2011-06-15 21:07 ` Re: PG 9.1 regression / row comparison? Denis de Bernardy <ddebernardy@yahoo.com>
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 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>
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