Re: Update from diferents conditions - Mailing list pgsql-general

From Nirmalya Lahiri
Subject Re: Update from diferents conditions
Date
Msg-id 20060416010459.63578.qmail@web30312.mail.mud.yahoo.com
Whole thread Raw
In response to Update from diferents conditions  ("Claudio Alejandro Ulloa Heinsohn" <caulloah@hotmail.com>)
List pgsql-general
 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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Question about selecting rows
Next
From: Nirmalya Lahiri
Date:
Subject: Re: Comparing text field