Matching a column against values in code

Поиск
Список
Период
Сортировка
Искать

Matching a column against values in code

От:
Tim <postgres@timkoop.com>
Дата:
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

Re: Matching a column against values in code

От:
PFC <lists@boutiquenumerique.com>
Дата:
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  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
>
FAQ