I also add my vote for allowing aliases in updates.
BTW, in my code I never use 'as' for table aliases. For column aliases
however, postgresql requires it.
Avi
On Monday, Jun 16, 2003, at 09:06 America/Chicago,
nolan@celery.tssi.com wrote:
>> 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?
> :-)