Tom is correct. It appears that nobody tested this example, which by the way seems unnecessarily complicated.
Sent from my iPhone > On Jul 17, 2023, at 6:22 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > "David G. Johnston" <david.g.johns...@gmail.com> writes: >>> On Mon, Jul 17, 2023 at 4:53 PM Curt Kolovson <ckolov...@gmail.com> wrote: >>> The actual results (shown below) are different than shown on this doc >>> page. > >> SPI_exec sees "INSERT 0 2" as the command tag from the SQL command you >> passed and so 2 is the output of the execq function call. >> No INFO messages appear because you did not include a returning clause. >> The 1 you passed to the call is immaterial if the query you supply doesn't >> produce a result set. > > I think his point is that this example does not behave as the > documentation claims. Which it does not, according to my > tests here. I find this a bit disturbing --- did we intentionally > change the behavior of SPI_exec somewhere along the line? > > regards, tom lane
