Обсуждение: UPDATE RETURNING?

Поиск
Список
Период
Сортировка

UPDATE RETURNING?

От
Tatsuo Ishii
Дата:
It seems there's an inconsitency between 8.2 press release and 8.2
docs.

http://www.postgresql.org/about/press/presskit82.html.en:

SQL 2003 Features: PostgreSQL, well known for standards compliance,
has added syntax for several more features introduced in the ANSI SQL
2003 specification, including: statistical aggregates, multi-row VALUE
statments, UPDATE RETURNING and multi-column aggregates.

http://www.postgresql.org/docs/8.2/static/sql-update.html:
This command conforms to the SQL standard, except that the FROM andRETURNING clauses are PostgreSQL extensions.

So, former says UPDATE RETURNING confirms SQL standard, while later
says it does not. Which one is correct?
--
Tatsuo Ishii
SRA OSS, Inc. Japan


Re: UPDATE RETURNING?

От
Tom Lane
Дата:
Tatsuo Ishii <ishii@postgresql.org> writes:
> It seems there's an inconsitency between 8.2 press release and 8.2
> docs.

> http://www.postgresql.org/about/press/presskit82.html.en:

> SQL 2003 Features: PostgreSQL, well known for standards compliance,
> has added syntax for several more features introduced in the ANSI SQL
> 2003 specification, including: statistical aggregates, multi-row VALUE
> statments, UPDATE RETURNING and multi-column aggregates.

UPDATE RETURNING is certainly not in SQL2003, so this is a mistake in
the press release.
        regards, tom lane