Re: is not distinct from any(...)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: is not distinct from any(...)
Date: 2008-09-19 14:53:40
Message-ID: 20993.1221836020@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Robert Haas" <robertmhaas(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2008-09-19 15:10:25 Re: setting Postgres client
Previous Message Markova, Nina 2008-09-19 14:49:58 Re: setting Postgres client