Re: Why can't you define a table alias on an update?

TODO updated:

    * Allow UPDATE, DELETE to handle table aliases for self-joins [delete]


---------------------------------------------------------------------------

Csaba Nagy wrote:
> Couldn't resist to not comment on this one:
>
> I find this feature would be extremely useful considering the fact that
> postgres supports the FROM clause in updates. This is already a useful
> extension to the SQL standard, so why not make it better ?
> I vote +1 to implement this !
>
> Cheers,
> Csaba.
>
> On Mon, 2003-06-16 at 15:42, Tom Lane wrote:
> > "Jim C. Nasby" <jim@nasby.net> writes:
> > > On Sun, Jun 15, 2003 at 06:36:57PM -0400, Tom Lane wrote:
> > >> It seems like a reasonable extension, but looking at the grammar just
> > >> now, I think that we'd have to turn SET from an unreserved keyword to a
> > >> reserved word to make this work.  Not sure how many peoples' databases
> > >> that would break ... but we'd probably get a few complaints ...
> >
> > > Would it be reasonable to have a setting that enabled/disabled this?
> >
> > No, unless you want to have two complete bison parsers in there.  AFAIK
> > there's no good way to alter the reserved-word status of a keyword on
> > the fly.  So either we do it, or not.
> >
> > I'm not necessarily opposed to doing it, I just wanted to raise a flag
> > and see if anyone reading this thread would complain.
> >
> >             regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073