| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | tomtrias(at)gmail(dot)com |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Please make a note regarding the PL/pgSQL FOUND variable |
| Date: | 2023-11-04 15:16:11 |
| Message-ID: | 3475325.1699110971@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
PG Doc comments form <noreply(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Trias | 2023-11-04 15:23:11 | Re: Please make a note regarding the PL/pgSQL FOUND variable |
| Previous Message | Laurenz Albe | 2023-11-04 06:05:28 | Re: Version 14/15 documentation Section "Alter Default Privileges" |