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 <[EMAIL PROTECTED]> 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
---------------------------(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
