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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
