Thread: Update from diferents conditions

Update from diferents conditions

From
"Claudio Alejandro Ulloa Heinsohn"
Date:
i want update differents rows of a table,  but each row with a diferente
condition, is possible make that update?



Re: Update from diferents conditions

From
Nirmalya Lahiri
Date:
 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