Re: Array intersection

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Array intersection
Date: 2007-10-17 16:49:01
Message-ID: 20071017164901.GM10098@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Sam

[1] http://www.postgresql.org/docs/8.1/static/functions-comparisons.html#AEN13394
[2] http://www.postgresql.org/docs/8.2/static/functions-comparisons.html#AEN14115

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2007-10-17 17:04:21 Re: Array intersection
Previous Message Sam Mason 2007-10-17 16:42:21 Re: Array intersection