Re: Update from diferents conditions

From: Nirmalya Lahiri <nirmalyalahiri(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Update from diferents conditions
Date: 2006-04-16 01:04:59
Message-ID: 20060416010459.63578.qmail@web30312.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hotmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nirmalya Lahiri 2006-04-16 01:23:29 Re: Comparing text field
Previous Message Michael Fuhr 2006-04-15 23:03:53 Re: Question about selecting rows