| From: | sergey(dot)klimkevich(at)gmail(dot)com |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | INSERT/UPDATE/DELETE with RETURNING |
| Date: | 2017-01-12 09:29:05 |
| Message-ID: | 20170112092905.24296.7733@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html
Description:
Following statement on
https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html page is
not entirely correct:
"For INSERT/UPDATE/DELETE with RETURNING, PL/pgSQL reports an error for more
than one returned row, even when STRICT is not specified."
This is only true for RETURNING with INTO clause. If INTO clause is omitted
while using RETURNING then the above statement is incorrect and must mention
the presence of INTO clause to be correct.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenichiro Tanaka | 2017-01-12 14:39:58 | pg_restore option data-only and section=data |
| Previous Message | georgthegreat | 2017-01-12 07:31:50 | Behavior of left join using is not covered by docs |