Update from diferents conditions

Started by Claudio Alejandro Ulloa Heinsohnalmost 20 years ago2 messagesgeneral
Jump to latest

i want update differents rows of a table, but each row with a diferente
condition, is possible make that update?

#2Nirmalya Lahiri
nirmalyalahiri@yahoo.com
In reply to: Claudio Alejandro Ulloa Heinsohn (#1)
Re: Update from diferents conditions

I think it is not possible using a single SQL command. You have to
issue separate SQL command for each row.

--- Claudio Alejandro Ulloa Heinsohn <caulloah@hotmail.com> wrote:

i want update differents rows of a table, but each row with a
diferente
condition, is possible make that update?

---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire
to
choose an index scan if your joining column's datatypes do
not
match

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com