Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group