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

Started by PG Bug reporting formover 8 years ago1 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.