Re: table alias nor valid for delete

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: table alias nor valid for delete
Дата
Msg-id 20020409135149.R98278-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на table alias nor valid for delete  (Jean-Luc Lachance <jllachan@nsd.ca>)
Список pgsql-general
Дерево обсуждения 
On Tue, 9 Apr 2002, Jean-Luc Lachance wrote:

> Hi all,
>
> I can't specify an alias for the table I want to delete from.
>
> Is this a bug or is that behavior mandated by the SQL standard?

Pretty sure it's at least SQL 92 spec...

<delete statement: searched> seems to have the form of:
DELETE FROM <table name> [WHERE <search condition>]

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why does this not work? (keyword 'TEXT')
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Sub-selects taking way too long..