two rows are inserted by SELECT execq('INSERT INTO a SELECT x + 2 FROM a', 1)

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)postgresql(dot)org
Cc: ruihaijiang(at)msn(dot)com
Subject: two rows are inserted by SELECT execq('INSERT INTO a SELECT x + 2 FROM a', 1)
Date: 2018-01-04 13:47:05
Message-ID: 20180104134705.17008.46415@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/spi-examples.html
Description:

I did some testing following this page:
https://www.postgresql.org/docs/9.6/static/spi-examples.html.

I got a different result.

According to the webpage, only one row is inserted by following SQL:

SELECT execq('INSERT INTO a SELECT x + 2 FROM a', 1);

But I ran this SQL and two rows were inserted.

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2018-01-04 14:09:11 J.2. Tool Sets/Appendix J. Documentation missing package
Previous Message Thomas Munro 2018-01-04 10:02:43 Element sup in namespace '' encountered in a, but no template matches.