Invalid statement in ref/insert.sgml

Started by Alexander Lakhinalmost 10 years ago2 messagesdocs
Jump to latest
#1Alexander Lakhin
exclusion@gmail.com

Hello,

It seems, that the statement "INSERT ... ON CONFLICT DO UPDATE tab SET
table_name.col = 1" is invalid in two ways. Patch attached.
Maybe it's worth to replace "UPDATE tab SET tab.col = 1" with "UPDATE
table_name SET table_name.col = 1" in ref/update.sgml (for consistency) too.

Best regards,
Alexander

Attachments:

ref-insert-fix-example.sgmltext/sgml; name=ref-insert-fix-example.sgmlDownload+2-2
ref-update-better-example.sgmltext/sgml; name=ref-update-better-example.sgmlDownload+1-1
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alexander Lakhin (#1)
Re: Invalid statement in ref/insert.sgml

Alexander Law <exclusion@gmail.com> writes:

It seems, that the statement "INSERT ... ON CONFLICT DO UPDATE tab SET
table_name.col = 1" is invalid in two ways. Patch attached.
Maybe it's worth to replace "UPDATE tab SET tab.col = 1" with "UPDATE
table_name SET table_name.col = 1" in ref/update.sgml (for consistency) too.

Pushed, thanks!

regards, tom lane

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs