diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 2656786d1e6..1345791e963 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -6007,8 +6007,9 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l <structfield>prosqlbody</structfield> <type>pg_node_tree</type> </para> <para> - Pre-parsed SQL function body. This will be used for language SQL - functions if the body is not specified as a string constant. + Pre-parsed SQL function body. This is used for SQL-language + functions when the body is given in SQL-standard notation + rather than as a string literal. It's null in other cases. </para></entry> </row> @@ -6036,9 +6037,16 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l <para> For compiled functions, both built-in and dynamically loaded, <structfield>prosrc</structfield> contains the function's C-language - name (link symbol). For all other currently-known language types, + name (link symbol). + For SQL-language functions, <structfield>prosrc</structfield> contains + the function's source text if that is specified as a string literal; + but if the function body is specified in SQL-standard style, + <structfield>prosrc</structfield> is unused (typically it's an empty + string) and <structfield>prosqlbody</structfield> contains the + pre-parsed definition. + For all other currently-known language types, <structfield>prosrc</structfield> contains the function's source - text. <structfield>probin</structfield> is unused except for + text. <structfield>probin</structfield> is null except for dynamically-loaded C functions, for which it gives the name of the shared library file containing the function. </para> |