Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B0CB19FB4D3 for ; Mon, 30 Apr 2007 21:47:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 07991-01 for ; Mon, 30 Apr 2007 21:46:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 981599FB3B3 for ; Mon, 30 Apr 2007 21:47:00 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l410kvKr011170; Mon, 30 Apr 2007 20:46:57 -0400 (EDT) To: "Collin Peters" cc: pgsql-sql@postgresql.org Subject: Re: "is not distinct from" syntax error? In-reply-to: References: Comments: In-reply-to "Collin Peters" message dated "Mon, 30 Apr 2007 17:03:03 -0700" Date: Mon, 30 Apr 2007 20:46:57 -0400 Message-ID: <11169.1177980417@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/280 X-Sequence-Number: 28280 "Collin Peters" writes: > However, when I do: > SELECT 1 IS NOT DISTINCT FROM 2 > I get "ERROR: syntax error at or near "DISTINCT"" > What is the problem here? Using a pre-8.2 server, likely. regards, tom lane