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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
