Postgres Pro
Downloads
Home   >   mailing lists

Re: "is not distinct from" syntax error? - Mailing list pgsql-sql

From Tom Lane
Subject Re: "is not distinct from" syntax error?
Date
Msg-id 11169.1177980417@sss.pgh.pa.us
Whole thread Raw
In response to "is not distinct from" syntax error?  ("Collin Peters" <cadiolis@gmail.com>)
List pgsql-sql
Tree view 
"Collin Peters" <cadiolis@gmail.com> 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

pgsql-sql by date:

Previous
From: "Collin Peters"
Date:
Subject: "is not distinct from" syntax error?
Next
From: Tom Lane
Date:
Subject: Re: Dynamic prepare possible in plpgsql?