From: | Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Array intersection |
Date: | 2007-10-17 18:02:07 |
Message-ID: | 20071017130207.3457de99@sinkhole.intrcomm.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 17 Oct 2007 17:49:01 +0100
Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
> On Wed, Oct 17, 2007 at 11:31:51AM -0500, Josh Trutwin wrote:
> > Is the =ANY specific to PG 8.2 or higher? On 8.1.10:
>
> It appears (according to [1] and [2]) that you may be able to just
> remove the '=' to get it working with 8.1.x. i.e.
>
> v ANY ('{1,2}')
>
> is correct in 8.1.x but in 8.2.x it's
>
> v = ANY ('{1,2}')
>
> I don't have an 8.1 box so I can't test unfortunatly.
= ANY appears to work in 8.1 - at least your function from the other
reply worked just fine on 8.1 and I have used = ANY in some other
queries.
Thanks,
Josh
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Trutwin | 2007-10-17 18:06:35 | Re: Array intersection |
Previous Message | Josh Trutwin | 2007-10-17 18:00:48 | Re: Array intersection |