1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
12 TITLE="PostgreSQL 7.4.1 Documentation"
13 HREF="index.html"><LINK
15 TITLE="System Catalogs"
16 HREF="catalogs.html"><LINK
19 HREF="catalog-pg-operator.html"><LINK
22 HREF="catalog-pg-rewrite.html"><LINK
25 HREF="stylesheet.css"><META
27 CONTENT="2003-12-22T03:48:47"></HEAD
33 SUMMARY="Header navigation table"
43 >PostgreSQL 7.4.1 Documentation</TH
51 HREF="catalog-pg-operator.html"
67 >Chapter 43. System Catalogs</TD
81 HREF="catalog-pg-rewrite.html"
95 NAME="CATALOG-PG-PROC"
108 > stores information about functions (or procedures).
109 The description of <TT
116 > contain more information about the meaning of
120 > The table contains data for aggregate functions as well as plain functions.
124 > is true, there should be a matching
145 ><COL><COL><COL><COL><THEAD
172 >Name of the function</TD
189 HREF="catalog-pg-namespace.html"
197 > The OID of the namespace that contains this function
215 HREF="catalog-pg-shadow.html"
223 >Owner of the function</TD
240 HREF="catalog-pg-language.html"
248 >Implementation language or call interface of this function</TD
264 >Function is an aggregate function</TD
280 >Function is a security definer (i.e., a <SPAN
300 > Function returns null if any call argument is null. In that
301 case the function won't actually be called at all. Functions
305 > must be prepared to handle
323 >Function returns a set (i.e., multiple values of the specified
343 > tells whether the function's
344 result depends only on its input arguments, or is affected by outside
353 which always deliver the same result for the same inputs.
361 whose results (for fixed inputs) do not change within a scan.
369 whose results may change at any time. (Use <TT
373 for functions with side-effects, so that calls to them cannot get
391 >Number of arguments</TD
408 HREF="catalog-pg-type.html"
416 >Data type of the return value</TD
433 HREF="catalog-pg-type.html"
441 >An array with the data types of the function arguments</TD
457 > This tells the function handler how to invoke the function. It
458 might be the actual source code of the function for interpreted
459 languages, a link symbol, a file name, or just about anything
460 else, depending on the implementation language/call convention.
477 >Additional information about how to invoke the function.
478 Again, the interpretation is language-specific.
495 >Access privileges</TD
504 > contains the function's C-language
505 name (link symbol) for compiled functions, both built-in and
506 dynamically loaded. For all other language types,
510 > contains the function's source
514 > is unused except for
515 dynamically-loaded C functions, for which it gives the name of the
516 shared library file containing the function.
524 SUMMARY="Footer navigation table"
535 HREF="catalog-pg-operator.html"
553 HREF="catalog-pg-rewrite.html"