From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Susanne Ebrecht <miracee(at)miracee(dot)de>, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: extension for sql update |
Date: | 2006-07-27 13:28:05 |
Message-ID: | 200607271328.k6RDS5519882@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> UPDATE mytab SET (foo, bar, baz) =
> >> (SELECT alpha, beta, gamma FROM othertab WHERE key = mytab.key);
>
> > That UPDATE example is interesting because I remember when using
> > Informix that I had to do a separate SELECT statement for each UPDATE
> > column I wanted to update. I didn't realize that you could group
> > columns and assign them from a single select --- clearly that is a
> > powerful syntax we should support some day.
>
> No question. The decision at hand is whether we want to look like
> we support it, when we don't yet. I'd vote not, because I think the
> main use-case for the row-on-the-left syntax is exactly this, and
> so I fear people will just get frustrated if they see it in the
> syntax synopsis and try to use it.
Agreed. My guess is that a soluion that allows SELECT to return
multiple values is going to be in another area of the code, and will
require us to remove this code once that is done.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Reich | 2006-07-27 13:39:07 | Re: [COMMITTERS] pgsql: /contrib/cube improvements: Update |
Previous Message | Tom Lane | 2006-07-27 13:17:20 | Re: extension for sql update |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Reich | 2006-07-27 13:39:07 | Re: [COMMITTERS] pgsql: /contrib/cube improvements: Update |
Previous Message | Bruce Momjian | 2006-07-27 13:20:21 | Re: LDAP lookup of connection parameters |