Re: Why can't you define a table alias on an update? - Mailing list pgsql-general

From nolan@celery.tssi.com
Subject Re: Why can't you define a table alias on an update?
Date
Msg-id 20030616140608.29413.qmail@celery.tssi.com
Whole thread Raw
In response to Re: Why can't you define a table alias on an update?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why can't you define a table alias on an update?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Why can't you define a table alias on an update?  (Avi Schwartz <avi@CFFtechnologies.com>)
List pgsql-general
> I'm not necessarily opposed to doing it, I just wanted to raise a flag
> and see if anyone reading this thread would complain.

Oracle permits table aliases on an update statement, though in Oracle
the word 'as' to denote a table alias is not permitted while 'as' is
optional for column aliases, whereas in pgsql it is REQUIRED in both cases.

Tom, is there an online reference to the full SQL standard for those of us
who don't have copies of it on our bookshelf or engrained in memory?  :-)
--
Mike Nolan



pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Why can't you define a table alias on an update?
Next
From: Tom Lane
Date:
Subject: Re: Sort memory not being released