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

Re: [HACKERS] extension for sql update

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
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: [HACKERS] extension for sql update
Date: 2006-07-27 15:42:19
Message-ID: 44C8DEDB.9080408@phlo.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane wrote:
> 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.

It has the advantage that inserts and updates look more "alike".
If your sql statements are generated by code, then that removes
the need of a special case for updates.

greetings, Florian Pflug

In response to

pgsql-hackers by date

Next:From: Jim NasbyDate: 2006-07-27 15:43:40
Subject: Re: [HACKERS] Resurrecting per-page cleaner for btree
Previous:From: Florian G. PflugDate: 2006-07-27 15:39:21
Subject: Re: GUC with units, details

pgsql-patches by date

Next:From: Jim NasbyDate: 2006-07-27 15:43:40
Subject: Re: [HACKERS] Resurrecting per-page cleaner for btree
Previous:From: Rocco AltierDate: 2006-07-27 15:35:26
Subject: Re: [HACKERS] [COMMITTERS] pgsql: /contrib/cube improvements:

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