diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2018-03-02 08:57:38 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2018-03-02 13:48:33 -0500 |
| commit | fd1a421fe66173fb9b85d3fe150afde8e812cbe4 (patch) | |
| tree | 24c80c87337ec2d1bb46ee8463207d0cfff5ffc3 /doc/src | |
| parent | 1733460f0205fc6d6bbe4c14911049a918c6e073 (diff) | |
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 <tgl@sss.pgh.pa.us>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 31 |
1 files changed, 14 insertions, 17 deletions
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$<replaceable><iteration count></replaceable>:<replaceable>&l </indexterm> <para> - The catalog <structname>pg_proc</structname> stores information about functions (or procedures). - See <xref linkend="sql-createfunction"/> - and <xref linkend="xfunc"/> for more information. + The catalog <structname>pg_proc</structname> stores information about + functions, procedures, aggregate functions, and window functions + (collectively also known as routines). See <xref + linkend="sql-createfunction"/>, <xref linkend="sql-createprocedure"/>, and + <xref linkend="xfunc"/> for more information. </para> <para> - The table contains data for aggregate functions as well as plain functions. - If <structfield>proisagg</structfield> is true, there should be a matching - row in <structfield>pg_aggregate</structfield>. + If <structfield>prokind</structfield> indicates that the entry is for an + aggregate function, there should be a matching row in + <structfield>pg_aggregate</structfield>. </para> <table> @@ -5157,17 +5159,12 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l </row> <row> - <entry><structfield>proisagg</structfield></entry> - <entry><type>bool</type></entry> - <entry></entry> - <entry>Function is an aggregate function</entry> - </row> - - <row> - <entry><structfield>proiswindow</structfield></entry> - <entry><type>bool</type></entry> + <entry><structfield>prokind</structfield></entry> + <entry><type>char</type></entry> <entry></entry> - <entry>Function is a window function</entry> + <entry><literal>f</literal> for a normal function, <literal>p</literal> + for a procedure, <literal>a</literal> for an aggregate function, or + <literal>w</literal> for a window function</entry> </row> <row> @@ -5264,7 +5261,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l <entry><structfield>prorettype</structfield></entry> <entry><type>oid</type></entry> <entry><literal><link linkend="catalog-pg-type"><structname>pg_type</structname></link>.oid</literal></entry> - <entry>Data type of the return value, or null for a procedure</entry> + <entry>Data type of the return value</entry> </row> <row> |