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
> 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.
In response to
pgsql-sql by date
|Next:||From: Josh Berkus||Date: 2004-04-29 19:20:01|
|Subject: Re: Equivalant of SQL Server's Nchar and NVARCHAR|
|Previous:||From: Marco Lazzeri||Date: 2004-04-29 17:37:11|
|Subject: Check a value in array|