This has been discussed a few hours ago on the mailing list on the
subject '[SQL] More efficient OR'
On Fri, 11 Feb 2005 10:12:52 -0600, Tim <postgres@timkoop.com> wrote:
> Hello all.
>
> I sometimes find myself needing an SQL query that will return all the
> rows of a table in which one column equals any one of a list of values I
> have in an array in code.
>
> Does anyone know of a better way to do this than to loop through the
> array and append an "or" comparison to the sql statement, like this?
>
> sqlString = sqlString + " or this_column='" + arrayOfValues[i] +"' ";
>
>
> If someone knows a command or function I can look up in the docs, just
> say the name and I'll look there. Thanks a lot everyone.
>
> --
> Tim
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>