Re: Bug in documentation: https://www.postgresql.org/docs/current/spi-examples.html - Mailing list pgsql-docs

From Tom Lane
Subject Re: Bug in documentation: https://www.postgresql.org/docs/current/spi-examples.html
Date
Msg-id 4124246.1689647806@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in documentation: https://www.postgresql.org/docs/current/spi-examples.html  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Bug in documentation: https://www.postgresql.org/docs/current/spi-examples.html
List pgsql-docs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Mon, Jul 17, 2023 at 6:22 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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?

> Appears to be a documentation fix oversight back in v9.0
> https://github.com/postgres/postgres/commit/2ddc600f8f0252a0864e85d5cc1eeb3b9687d7e9

Ah, thanks for the pointer.  I'd just been trying to bisect where
between 8.4 and 9.0 it changed, but failed because early-9.0 versions
don't build at all with current bison :-(

Anyway, given that the example needs updating, how should we do that
exactly?  Is it worth demonstrating both the behavior with RETURNING
and that without?  If not, which one to show?

            regards, tom lane



pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Bug in documentation: https://www.postgresql.org/docs/current/spi-examples.html
Next
From: Curt Kolovson
Date:
Subject: Re: Bug in documentation: https://www.postgresql.org/docs/current/spi-examples.html