Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D0786B5D80B for ; Tue, 14 Jun 2011 23:40:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 90462-01 for ; Wed, 15 Jun 2011 02:40:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mbx.knossos.net.nz (mbx.knossos.net.nz [202.160.48.10]) by mail.postgresql.org (Postfix) with ESMTP id 3AC91B5DC0F for ; Tue, 14 Jun 2011 23:40:39 -0300 (ADT) Received: from [10.1.1.3] (60-234-150-59.bitstream.orcon.net.nz [60.234.150.59]) (authenticated bits=0) by mbx.knossos.net.nz (8.14.4/8.14.4) with ESMTP id p5F2eaKB002391 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Wed, 15 Jun 2011 14:40:37 +1200 Message-ID: <4DF81BA0.3000601@archidevsys.co.nz> Date: Wed, 15 Jun 2011 14:40:32 +1200 From: Gavin Flower Organization: ArchiDevSys User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110428 Fedora/3.1.10-1.fc14 Lightning/1.0b3pre Thunderbird/3.1.10 MIME-Version: 1.0 To: ddebernardy@yahoo.com CC: pgsql-testers@postgresql.org Subject: Re: PG 9.1 regression / row comparison? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/2 X-Sequence-Number: 243 [...] > 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