From fd1a421fe66173fb9b85d3fe150afde8e812cbe4 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 2 Mar 2018 08:57:38 -0500 Subject: Add prokind column, replacing proisagg and proiswindow The new column distinguishes normal functions, procedures, aggregates, and window functions. This replaces the existing columns proisagg and proiswindow, and replaces the convention that procedures are indicated by prorettype == 0. Also change prorettype to be VOIDOID for procedures. Reviewed-by: Tom Lane Reviewed-by: Michael Paquier --- doc/src/sgml/catalogs.sgml | 31 ++++++++++++++----------------- 1 file changed, 14 insertions(+), 17 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 71e20f27409..a0e6d7062b0 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -5062,15 +5062,17 @@ SCRAM-SHA-256$<iteration count>:&l - The catalog pg_proc stores information about functions (or procedures). - See - and for more information. + The catalog pg_proc stores information about + functions, procedures, aggregate functions, and window functions + (collectively also known as routines). See , , and + for more information. - The table contains data for aggregate functions as well as plain functions. - If proisagg is true, there should be a matching - row in pg_aggregate. + If prokind indicates that the entry is for an + aggregate function, there should be a matching row in + pg_aggregate. @@ -5157,17 +5159,12 @@ SCRAM-SHA-256$<iteration count>:&l - proisagg - bool - - Function is an aggregate function - - - - proiswindow - bool + prokind + char - Function is a window function + f for a normal function, p + for a procedure, a for an aggregate function, or + w for a window function @@ -5264,7 +5261,7 @@ SCRAM-SHA-256$<iteration count>:&l prorettype oid pg_type.oid - Data type of the return value, or null for a procedure + Data type of the return value -- cgit v1.2.3