From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Subject: | Re: Is this on the to-do list? |
Date: | 2009-01-21 03:05:20 |
Message-ID: | 200901202205.20519.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Monday 19 January 2009 18:13:51 Bruce Momjian wrote:
> Thomas Kellerer wrote:
> > A B wrote on 18.01.2009 22:43:
> > > From the docs:
> > > http://www.postgresql.org/docs/8.3/interactive/sql-update.html
> > >
> > > "According to the standard, the column-list syntax should allow a list
> > > of columns to be assigned from a single row-valued expression, such as
> > > a sub-select:
> > > UPDATE accounts SET (contact_last_name, contact_first_name) =
> > > (SELECT last_name, first_name FROM salesmen
> > > WHERE salesmen.id = accounts.sales_id);
> > > This is not currently implemented ? the source must be a list of
> > > independent expressions."
> > >
> > > Is this feature going into postgresql any day soon? :-)
> >
> > It's on the TODO list:
> >
> > http://wiki.postgresql.org/wiki/Todo#UPDATE
>
> Also, I don't know if anyone working on this item for 8.4 or 8.5.
>
Probably because there is a work-around...
UPDATE accounts SET contact_last_name = x.last_name, set contact_first_name =
x.first_name FROM (select last_name, first_name from salesmen where
salesmen.id = accounts.sales_id) x
Which is great if you just want to get this done, but sucks if you wanted the
specific syntax from above.
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2009-01-21 04:08:56 | Re: Database schema & data synchronizer software for PostgreSQL? |
Previous Message | Robert Treat | 2009-01-21 02:51:25 | Re: Database schema & data synchronizer software for PostgreSQL? |