Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id D31BAB5DF58 for ; Wed, 8 Jun 2011 11:52:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 99332-04 for ; Wed, 8 Jun 2011 14:52:20 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm10-vm0.bullet.mail.sp2.yahoo.com (nm10-vm0.bullet.mail.sp2.yahoo.com [98.139.91.198]) by mail.postgresql.org (Postfix) with SMTP id 590A5B5DF8C for ; Wed, 8 Jun 2011 11:52:20 -0300 (ADT) Received: from [98.139.91.70] by nm10.bullet.mail.sp2.yahoo.com with NNFMP; 08 Jun 2011 14:52:19 -0000 Received: from [98.139.91.1] by tm10.bullet.mail.sp2.yahoo.com with NNFMP; 08 Jun 2011 14:52:19 -0000 Received: from [127.0.0.1] by omp1001.mail.sp2.yahoo.com with NNFMP; 08 Jun 2011 14:52:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 846984.74458.bm@omp1001.mail.sp2.yahoo.com Received: (qmail 76636 invoked by uid 60001); 8 Jun 2011 14:52:19 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1307544739; bh=dSLXEpLP0+IcIlLxDDHTC7cI43+/QpuZoEKuRkoT3F8=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=1zweg8/yLO40OyGGjAFJvJ8AxcWBeNOfqzBbYJI5rO8fTOhYlusojlRLCEOE+LNbWW+jnsqB5FdSlIIWXKA8zI/6XLXXqyF7tdHX0ll08RregDTEvuAOHBexEPiXJsuGIcYLMW3l4rjA0RGYBu3egR1TD2i5dyssl9X7pSgNtts= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=HGobuE8JvefWZ4jXOHyRyI/MvUmTIyJ7IChffFi2ofjxAeGAzMZn+02d14oO+vMjEvcfmGZI9KkFcuP/BPUjjf3EfvT5I+jOXocHCNSYhsLKaOv0+yycqwNRfVsHNpEQq1ZAG+i7/tvofF6c+Ds/5Ff0X8WaFCOCj762fz5/XxY=; Message-ID: <537229.49593.qm@web112417.mail.gq1.yahoo.com> X-YMail-OSG: U2m_l3EVM1ke6oA2q6PDObTwMZqMJMkJNPMcDqzmBceoFXT hOj1wuHpsaIr9XXFe1_ZqwPEY5nKRQP8W5mAryhqglIECTKcDP03Pw2g3f01 RcSRHWbCBwCQnaYDnNypfNhE9DkOR4tMWJ4.Zvzg.LvDbVwvSphu_7_.AJzF vCLwvCGkOn_GlqjDoDCVygzUO26GPCaze07LarLIx54g4gRt52x9ykGo8H8_ RgyX9SSDciuJJuRk2Fba3X_C2NT.Q7JuKhQIdboroDkDKYhXzrlarxWl6f2A ItJnekX_o6lBCYZT7vLdHFgGZsd1TucRkCii3VVNM6wpReDNl2wx6GjFpxN1 S.xYSDYMnYxGUB8dYp2Xx3KDK9r0CWaRD8igcqErgXdkySr.PTcWbS7B5ZQy zO50_jn10FLdGaw-- Received: from [213.165.181.153] by web112417.mail.gq1.yahoo.com via HTTP; Wed, 08 Jun 2011 07:52:19 PDT X-Mailer: YahooMailWebService/0.8.111.304355 Date: Wed, 8 Jun 2011 07:52:19 -0700 (PDT) From: Denis de Bernardy Reply-To: Denis de Bernardy Subject: PG 9.1 regression / row comparison? To: "pgsql-testers@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.508 tagged_above=-10 required=5 tests=BAYES_05=-0.5, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/1 X-Sequence-Number: 242 I seem to remember that each of the following three statements worked in PG= 9.0.=A0Is the last one failing expected in 9.1? Or is it due to the variou= s 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...)=0A=0Atest=3D# select row(1,2) =3D row(1= ,2); -- returns t=0Atest=3D# select row(1,2) is distinct from row(1,2); -- = returns f=0A=0Atest=3D# select row(1,2) <> row(1,2);=0A=0AERROR: =A0could n= ot determine interpretation of row comparison operator <>=0ALINE 1: select = row(1,2) <> row(1,2);=0A=A0=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0^= =0AHINT: =A0Row comparison operators must be associated with btree operator= families.