Re: PG 9.1 regression / row comparison?
| От | Denis de Bernardy |
|---|---|
| Тема | Re: PG 9.1 regression / row comparison? |
| Дата | |
| Msg-id | 743036.48052.qm@web112401.mail.gq1.yahoo.com обсуждение исходный текст |
| Ответ на | Re: PG 9.1 regression / row comparison? (Gavin Flower <GavinFlower@archidevsys.co.nz>) |
| Список | 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
В списке pgsql-testers по дате отправления: