Thread: 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 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
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