Postgres Pro
Downloads
Home   >   mailing lists

Re: is not distinct from any(...) - Mailing list pgsql-general

From Tom Lane
Subject Re: is not distinct from any(...)
Date
Msg-id 20993.1221836020@sss.pgh.pa.us
Whole thread Raw
In response to is not distinct from any(...)  ("Robert Haas" <robertmhaas@gmail.com>)
List pgsql-general
Tree view 
"Robert Haas" <robertmhaas@gmail.com> writes:
> That doesn't seem to work, because IS NOT DISTINCT FROM is not an
> operator.

Yah :-(

> So then I tried creating an operator === (anyelement,
> anyelement) that just does IS NOT DISTINCT FROM and writing:
> select 1 === any(array[1]);
> which got me:
> ERROR:  could not find array type for data type anyelement

FWIW, it seems to work in 8.3.

            regards, tom lane

pgsql-general by date:

Previous
From: "Markova, Nina"
Date:
Subject: Re: setting Postgres client
Next
From: Steve Clark
Date:
Subject: Re: setting Postgres client