Re: [PATCHES] extension for sql update

From: David Fetter <david(at)fetter(dot)org>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, Susanne Ebrecht <miracee(at)miracee(dot)de>
Subject: Re: [PATCHES] extension for sql update
Date: 2006-08-12 20:16:57
Message-ID: 20060812201657.GB19427@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Fri, Aug 11, 2006 at 05:11:03PM -0500, Jim C. Nasby wrote:
> 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.

+1 here, too. :)

Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-08-12 21:43:22 Re: Buildfarm owners: check if your HEAD build is stuck
Previous Message David Fetter 2006-08-12 20:06:37 Re: psql and INSERT/UPDATE/DELETE RETURNING

Browse pgsql-patches by date

  From Date Subject
Next Message Hannu Krosing 2006-08-12 21:59:37 Re: Forcing current WAL file to be archived
Previous Message Alvaro Herrera 2006-08-12 19:35:12 ECPG regress tests fix for VPATH builds