SEO

#1 (**permalink**) 04-09-2008, 09:19 AM

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

#2 (**permalink**) 04-09-2008, 09:19 AM

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Update from diferents conditions