Postgres Pro
Downloads
Home   >   mailing lists

UPDATE query with variable number of OR conditions in WHERE - Mailing list pgsql-sql

From JORGE MALDONADO
Subject UPDATE query with variable number of OR conditions in WHERE
Date
Msg-id CAAY=A7-JA3iaitwjh+kYAsq0frUqBGkauwYVSSWBqz-feDAO7Q@mail.gmail.com
Whole thread Raw
Responses Re: UPDATE query with variable number of OR conditions in WHERE
List pgsql-sql
Tree view
I am building an UPDATE query at run-time and one of the fields I want to include in the WHERE condition may repeat several times, I do not know how many. 

UPDATE table1 
SET field1 = "some value" 
WHERE (field2 = value_1 OR field2 = value_2 OR .....OR field2 = value_n)

I build such a query using a programming language and, after that, I execute it. Is this a good approach to build such a query?

Respectfully,
Jorge Maldonado

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: bug in 9.2.2 ? subquery accepts wrong column name : upd
Next
From: Ben Morrow
Date:
Subject: Re: UPDATE query with variable number of OR conditions in WHERE