UPDATE query with variable number of OR conditions in WHERE

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: UPDATE query with variable number of OR conditions in WHERE
Date: 2013-03-14 22:25:48
Message-ID: CAAY=A7-JA3iaitwjh+kYAsq0frUqBGkauwYVSSWBqz-feDAO7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ben Morrow 2013-03-14 23:58:11 Re: UPDATE query with variable number of OR conditions in WHERE
Previous Message Tom Lane 2013-03-14 16:17:46 Re: bug in 9.2.2 ? subquery accepts wrong column name : upd