Re: extension for sql update

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Susanne Ebrecht <miracee(at)miracee(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: extension for sql update
Date: 2006-07-27 12:30:21
Message-ID: 5490.1154003421@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Susanne Ebrecht <miracee(at)miracee(dot)de> writes:
> ... We could provide the mixed update syntax and leave the
> typed row value expression for the next release. Do you agree?

I don't really see the point --- the patch won't provide any new
functionality in anything like its current form, because you can
always just write the separate expressions in the simple one to
one way. If we do offer the row-on-the-left syntax then people
will try to put sub-selects on the right, and won't get anything
beyond an unhelpful "syntax error" message. So my vote would be
to leave it alone until we have a more complete implementation.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2006-07-27 12:47:20 Re: About "ALTER USER" command
Previous Message Tom Lane 2006-07-27 12:25:17 Re: GUC with units, details

Browse pgsql-patches by date

  From Date Subject
Next Message Albe Laurenz 2006-07-27 12:57:39 Re: LDAP lookup of connection parameters
Previous Message ITAGAKI Takahiro 2006-07-27 09:46:07 Re: Resurrecting per-page cleaner for btree