On Wed, 17 Oct 2007 17:49:01 +0100
Sam Mason <sam@samason.me.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