52.38 pg_proc (postgresql version 14)

Started by PG Bug reporting formalmost 2 years ago2 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/14/catalog-pg-proc.html
Description:

I don't know if this is a documentation problem or an error in pg_proc.

The document, for the "prokind" column state the following:
f for a normal function, p for a procedure, a for an aggregate
function, or w for a window function.

However, there "f" is used for *both* functions and procedures.

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: PG Bug reporting form (#1)
Re: 52.38 pg_proc (postgresql version 14)

On Mon, 2024-05-20 at 21:07 +0000, PG Doc comments form wrote:

Page: https://www.postgresql.org/docs/14/catalog-pg-proc.html
Description:

I don't know if this is a documentation problem or an error in pg_proc.

The document, for the "prokind" column state the following:
f for a normal function, p for a procedure, a for an aggregate
function, or w for a window function.

However, there "f" is used for *both* functions and procedures.

I cannot reproduce that:

CREATE PROCEDURE noop() LANGUAGE plpgsql AS 'BEGIN NULL; END;';

SELECT prokind FROM pg_proc WHERE proname = 'noop';

prokind
═════════
p
(1 row)

Yours,
Laurenz Albe