Re: queries problems - Mailing list pgsql-sql

From Tom Lane
Subject Re: queries problems
Date
Msg-id 27001.1126225013@sss.pgh.pa.us
Whole thread Raw
In response to Re: queries problems  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Michael Fuhr <mike@fuhr.org> writes:
> I don't know if there's an easier way to check if an int2 is a
> member of an int2vector, but you could write a function to convert
> an int2vector to an int2 array and then use an "= ANY" expression.

FWIW, as of 8.1 an int2vector *is* an int2 array, so = ANY just works.
        regards, tom lane


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: queries problems
Next
From: miwalsh
Date:
Subject: Numeric Columns