Re: [PATCHES] extension for sql update

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