To: Tim <postgres@timkoop.com>, pgsql-sql@postgresql.org
Subject: Re: Matching a column against values in code
References: <420CD984.8010608@timkoop.com>
Message-ID: <opsma278btth1vuj@musicbox>
From: PFC <lists@boutiquenumerique.com>
Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?=
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Date: Wed, 16 Feb 2005 21:01:10 +0100
In-Reply-To: <420CD984.8010608@timkoop.com>
User-Agent: Opera M2/7.54u1 (Linux, build 892)


	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
>