From: Tom Lane <tgl@sss.pgh.pa.us>
To: tomtrias@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Please make a note regarding the PL/pgSQL FOUND variable
Date: Sat, 04 Nov 2023 11:16:11 -0400
Message-ID: <3475325.1699110971@sss.pgh.pa.us> (raw)
In-Reply-To: <169894333941.1769272.13207972370571788231@wrigleys.postgresql.org>
References: <169894333941.1769272.13207972370571788231@wrigleys.postgresql.org>
PG Doc comments form <noreply@postgresql.org> writes:
> Since I was recently bitten by the fact that CREATE TABLE AS doesn't set the
> PL/pgSQL variable FOUND, it would be nice if that were explicitly noted in
> the documentation. Alternatively, if it COULD set the FOUND variable, that
> would be great, although I realize the difficulty of that when coupled with
> IF NOT EXISTS.
The documentation of FOUND is already quite explicit about which kinds
of statements set it:
https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
I'm disinclined to put notes about PL/pgSQL features into command
reference pages that have nothing to do with PL/pgSQL.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, tomtrias@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Please make a note regarding the PL/pgSQL FOUND variable
In-Reply-To: <3475325.1699110971@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox