Re: Check a value in array

Il gio, 2004-04-29 alle 19:56, Rod Taylor ha scritto:
> On Thu, 2004-04-29 at 13:37, Marco Lazzeri wrote:
> > Hi all.
> > 
> > I have to check if a value is in an array.
> > 
> > I've got a date array in a table and I would like to perform queries
> > like:
> > 
> > SELECT * FROM table WHERE date IN dates_array;
> 
> If you're using 7.4 or later, try:
> 
>     SELECT * FROM table WHERE date = ANY(dates_array);
> 
> This will work without the contrib package.

Thank you Rod, I forgot to specify I'm using PostgreSQL 7.3.5.