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

Поиск
Список
Период
Сортировка
От nolan@celery.tssi.com
Тема Re: Why can't you define a table alias on an update?
Дата
Msg-id 20030616140608.29413.qmail@celery.tssi.com
обсуждение исходный текст
Ответ на 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?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Why can't you define a table alias on an update?  (Avi Schwartz <avi@CFFtechnologies.com>)
Список 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 по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: Why can't you define a table alias on an update?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Sort memory not being released