UPDATE RETURNING?
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 and
RETURNING 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
Tatsuo Ishii <ishii@postgresql.org> writes:
It seems there's an inconsitency between 8.2 press release and 8.2
docs.
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