Postgres Pro
Downloads
Home   >   mailing lists

Re: Array intersection - Mailing list pgsql-general

From Sam Mason
Subject Re: Array intersection
Date
Msg-id 20071017164901.GM10098@samason.me.uk
Whole thread Raw
In response to Re: Array intersection  (Josh Trutwin <josh@trutwins.homeip.net>)
Responses Re: Array intersection  (Josh Trutwin <josh@trutwins.homeip.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Array intersection
Next
From: David Fetter
Date:
Subject: Re: Array intersection