Re: [PATCHES] extension for sql update - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: [PATCHES] extension for sql update
Date
Msg-id 20060811221103.GZ27928@pervasive.com
Whole thread Raw
In response to Re: [PATCHES] extension for sql update  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [PATCHES] extension for sql update
List pgsql-hackers
On Fri, Aug 11, 2006 at 10:59:45AM -0400, Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > Bruce Momjian wrote:
> > > Are we sure we don't want the patch for a non-subquery version of SET
> > > ROW for 8.2?
> > >
> > >         o Allow UPDATE tab SET ROW (col, ...) = (...) for updating
> > > multiple columns
> > 
> > It seems to be moderately useful as a notational convenience for now.
> > 
> > Is it too hard to rip it back out once the full row support arrives?  
> > That seems speculation at best anyway.
> 
> That's what I was thinking.  Glad someone else replied.  ;-)

If you're looking for votes, +1. I'll gladly take a subset of the SQL
standard UPDATE table SET (...) = (...) over having nothing.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: 8.2 features status
Next
From: "Andrew Hammond"
Date:
Subject: perl namespace for postgres specific modules?