pg_proc.h File Reference

#include "catalog/genbki.h"

Include dependency graph for pg_proc.h:

Go to the source code of this file.

Defines
#define	ProcedureRelationId   1255
#define	ProcedureRelation_Rowtype_Id   81
#define	Natts_pg_proc   27
#define	Anum_pg_proc_proname   1
#define	Anum_pg_proc_pronamespace   2
#define	Anum_pg_proc_proowner   3
#define	Anum_pg_proc_prolang   4
#define	Anum_pg_proc_procost   5
#define	Anum_pg_proc_prorows   6
#define	Anum_pg_proc_provariadic   7
#define	Anum_pg_proc_protransform   8
#define	Anum_pg_proc_proisagg   9
#define	Anum_pg_proc_proiswindow   10
#define	Anum_pg_proc_prosecdef   11
#define	Anum_pg_proc_proleakproof   12
#define	Anum_pg_proc_proisstrict   13
#define	Anum_pg_proc_proretset   14
#define	Anum_pg_proc_provolatile   15
#define	Anum_pg_proc_pronargs   16
#define	Anum_pg_proc_pronargdefaults   17
#define	Anum_pg_proc_prorettype   18
#define	Anum_pg_proc_proargtypes   19
#define	Anum_pg_proc_proallargtypes   20
#define	Anum_pg_proc_proargmodes   21
#define	Anum_pg_proc_proargnames   22
#define	Anum_pg_proc_proargdefaults   23
#define	Anum_pg_proc_prosrc   24
#define	Anum_pg_proc_probin   25
#define	Anum_pg_proc_proconfig   26
#define	Anum_pg_proc_proacl   27
#define	PROVOLATILE_IMMUTABLE   'i'
#define	PROVOLATILE_STABLE   's'
#define	PROVOLATILE_VOLATILE   'v'
#define	PROARGMODE_IN   'i'
#define	PROARGMODE_OUT   'o'
#define	PROARGMODE_INOUT   'b'
#define	PROARGMODE_VARIADIC   'v'
#define	PROARGMODE_TABLE   't'
Typedefs
typedef FormData_pg_proc *	Form_pg_proc
Functions
	CATALOG (pg_proc, 1255) BKI_BOOTSTRAP BKI_ROWTYPE_OID(81) BKI_SCHEMA_MACRO
	DATA (insert OID=1242(boolinPGNSP PGUID 12 1 0 0 0 f f f f t f i 1 0 16"2275"_null_ _null_ _null_ _null_ boolin _null_ _null_ _null_))
	DESCR ("I/O")
	DESCR ("convert char to int4")
	DESCR ("convert int4 to char")
	DESCR ("length")
	DESCR ("PostgreSQL version string")
	DESCR ("restriction selectivity of = and related operators")
	DESCR ("restriction selectivity of <> and related operators")
	DESCR ("restriction selectivity of > and related operators on scalar datatypes")
	DESCR ("join selectivity of <> and related operators")
	DESCR ("join selectivity of > and related operators on scalar datatypes")
	DESCR ("restriction selectivity for area-comparison operators")
	DESCR ("join selectivity for area-comparison operators")
	DESCR ("aggregate transition function")
	DESCR ("larger of two")
	DESCR ("smaller of two")
	DESCR ("round to nearest integer")
	DESCR ("truncate to integer")
	DESCR ("smallest integer >= value")
	DESCR ("largest integer <= value")
	DESCR ("sign of value")
	DESCR ("natural exponential (e^x)")
	DESCR ("natural logarithm")
	DESCR ("convert int2 to float8")
	DESCR ("convert int2 to float4")
	DESCR ("convert float8 to int2")
	DESCR ("convert float4 to int2")
	DESCR ("tinterval to reltime")
	DESCR ("current date and time (abstime)")
	DESCR ("end of interval")
	DESCR ("current date and time - increments during transactions")
	DESCR ("finite abstime?")
	DESCR ("bucket number of operand in equidepth histogram")
	DESCR ("convert float4 to float8")
	DESCR ("convert float8 to float4")
	DESCR ("convert int2 to int4")
	DESCR ("convert int4 to int2")
	DESCR ("convert int4 to float8")
	DESCR ("convert float8 to int4")
	DESCR ("convert int4 to float4")
	DESCR ("convert float4 to int4")
	DESCR ("btree(internal)")
	DESCR ("less-equal-greater")
	DESCR ("sort support")
	DESCR ("convert char(n) to text")
	DESCR ("convert name to text")
	DESCR ("convert text to name")
	DESCR ("convert name to char(n)")
	DESCR ("convert char(n) to name")
	DESCR ("hash(internal)")
	DESCR ("hash")
	DESCR ("convert int8 to int4")
	DESCR ("convert int4 to int8")
	DESCR ("convert int8 to float8")
	DESCR ("convert float8 to int8")
	DESCR ("convert int8 to float4")
	DESCR ("convert float4 to int8")
	DESCR ("convert int8 to int2")
	DESCR ("convert int2 to int8")
	DESCR ("adjust char() to typmod length")
	DESCR ("transform a varchar length coercion")
	DESCR ("adjust varchar() to typmod length")
	DESCR ("deprecated, use current_user instead")
	DESCR ("octet length")
	DESCR ("get byte")
	DESCR ("set byte")
	DESCR ("get bit")
	DESCR ("set bit")
	DESCR ("substitute portion of string")
	DESCR ("current user name")
	DESCR ("session user name")
	DESCR ("array dimensions")
	DESCR ("number of array dimensions")
	DESCR ("array lower dimension")
	DESCR ("array upper dimension")
	DESCR ("array length")
	DESCR ("append element onto end of array")
	DESCR ("prepend element onto front of array")
	DESCR ("split delimited text into text[]")
	DESCR ("concatenate array elements, using delimiter, into text")
	DESCR ("split delimited text into text[], with null string")
	DESCR ("concatenate array elements, using delimiter and null string, into text")
	DESCR ("array subscripts generator")
	DESCR ("array constructor with value")
	DESCR ("expand array to set of rows")
	DESCR ("remove any occurrences of an element from an array")
	DESCR ("replace any occurrences of an element in an array")
	DESCR ("aggregate final function")
	DESCR ("concatenate aggregate input into an array")
	DESCR ("array typanalyze")
	DESCR ("restriction selectivity for array-containment operators")
	DESCR ("join selectivity for array-containment operators")
	DESCR ("storage manager")
	DESCR ("large object import")
	DESCR ("large object export")
	DESCR ("increment")
	DESCR ("gist(internal)")
	DESCR ("position of substring")
	DESCR ("convert char to char(n)")
	DESCR ("name of the current database")
	DESCR ("get the currently executing query")
	DESCR ("output money amount as words")
	DESCR ("convert money to numeric")
	DESCR ("convert numeric to money")
	DESCR ("convert int4 to money")
	DESCR ("convert int8 to money")
	DESCR ("modulus")
	DESCR ("convert text to char")
	DESCR ("convert char to text")
	DESCR ("large object open")
	DESCR ("large object close")
	DESCR ("large object read")
	DESCR ("large object write")
	DESCR ("large object seek")
	DESCR ("large object seek (64 bit)")
	DESCR ("large object create")
	DESCR ("large object position")
	DESCR ("large object position (64 bit)")
	DESCR ("truncate large object")
	DESCR ("truncate large object (64 bit)")
	DESCR ("large object unlink (delete)")
	DESCR ("box area")
	DESCR ("box width")
	DESCR ("box height")
	DESCR ("area of a closed path")
	DESCR ("box diagonal")
	DESCR ("slope between points")
	DESCR ("convert points to line segment")
	DESCR ("adjust timestamp to new time zone")
	DESCR ("add/update ACL item")
	DESCR ("remove ACL item")
	DESCR ("contains")
	DESCR ("make ACL item")
	DESCR ("TODO")
	DESCR ("convert ACL item array to table, for use by information schema")
	DESCR ("I/O typmod")
	DESCR ("format a type oid and atttypmod to canonical SQL")
	DESCR ("convert UNIX epoch to timestamptz")
	DESCR ("extract field from timestamp with time zone")
	DESCR ("extract field from interval")
	DESCR ("convert abstime to timestamp with time zone")
	DESCR ("convert date to timestamp with time zone")
	DESCR ("promote groups of 24 hours to numbers of days and promote groups of 30 days to numbers of months")
	DESCR ("promote groups of 24 hours to numbers of days")
	DESCR ("promote groups of 30 days to numbers of months")
	DESCR ("convert date and time to timestamp with time zone")
	DESCR ("convert reltime to interval")
	DESCR ("convert timestamp with time zone to date")
	DESCR ("convert abstime to date")
	DESCR ("convert timestamp with time zone to abstime")
	DESCR ("age of a transaction ID, in transactions before current transaction")
	DESCR ("convert interval to reltime")
	DESCR ("date difference preserving months and years")
	DESCR ("transform an interval length coercion")
	DESCR ("adjust interval precision")
	DESCR ("get description for object id and catalog name")
	DESCR ("get description for table column")
	DESCR ("get description for object id and shared catalog name")
	DESCR ("truncate timestamp with time zone to specified units")
	DESCR ("truncate interval to specified units")
	DESCR ("increment, ignores second argument")
	DESCR ("intervals overlap?")
	DESCR ("extract field from time with time zone")
	DESCR ("convert int8 to oid")
	DESCR ("convert oid to int8")
	DESCR ("trigger to suppress updates when new and old records match")
	DESCR ("latest tid of a tuple")
	DESCR ("current transaction time")
	DESCR ("current statement time")
	DESCR ("current clock time")
	DESCR ("restriction selectivity for position-comparison operators")
	DESCR ("join selectivity for position-comparison operators")
	DESCR ("restriction selectivity for containment comparison operators")
	DESCR ("join selectivity for containment comparison operators")
	DESCR ("convert timestamp to time")
	DESCR ("character length")
	DESCR ("base 10 logarithm")
	DESCR ("square root")
	DESCR ("cube root")
	DESCR ("exponentiation")
	DESCR ("deprecated, use two-argument form instead")
	DESCR ("print type names of oidvector field")
	DESCR ("convert date and time with time zone to timestamp with time zone")
	DESCR ("convert abstime to time")
	DESCR ("convert time to interval")
	DESCR ("extract field from abstime")
	DESCR ("extract field from reltime")
	DESCR ("extract field from date")
	DESCR ("extract field from time")
	DESCR ("date difference from today preserving months and years")
	DESCR ("convert timestamp with time zone to time with time zone")
	DESCR ("finite date?")
	DESCR ("finite timestamp?")
	DESCR ("finite interval?")
	DESCR ("factorial")
	DESCR ("absolute value")
	DESCR ("convert varchar to name")
	DESCR ("convert name to varchar")
	DESCR ("current schema name")
	DESCR ("current schema search list")
	DESCR ("vertically aligned")
	DESCR ("horizontally aligned")
	DESCR ("parallel")
	DESCR ("perpendicular")
	DESCR ("vertical")
	DESCR ("horizontal")
	DESCR ("center of")
	DESCR ("convert interval to time")
	DESCR ("convert points to box")
	DESCR ("path closed?")
	DESCR ("path open?")
	DESCR ("close path")
	DESCR ("open path")
	DESCR ("convert x, y to point")
	DESCR ("convert polygon to bounding box")
	DESCR ("convert polygon to path")
	DESCR ("convert box to polygon")
	DESCR ("convert path to polygon")
	DESCR ("area of circle")
	DESCR ("diameter of circle")
	DESCR ("radius of circle")
	DESCR ("convert point and radius to circle")
	DESCR ("convert polygon to circle")
	DESCR ("convert vertex count and circle to polygon")
	DESCR ("convert box to circle")
	DESCR ("convert circle to box")
	DESCR ("convert to tinterval")
	DESCR ("construct line from points")
	DESCR ("distance between endpoints")
	DESCR ("sum of path segments")
	DESCR ("diagonal of")
	DESCR ("convert circle to 12-vertex polygon")
	DESCR ("number of points")
	DESCR ("matches LIKE expression")
	DESCR ("does not match LIKE expression")
	DESCR ("sequence next value")
	DESCR ("sequence current value")
	DESCR ("set sequence value")
	DESCR ("set sequence value and is_called status")
	DESCR ("sequence parameters, for use by information schema")
	DESCR ("random value")
	DESCR ("set random seed")
	DESCR ("arcsine")
	DESCR ("arccosine")
	DESCR ("arctangent")
	DESCR ("arctangent, two arguments")
	DESCR ("sine")
	DESCR ("cosine")
	DESCR ("tangent")
	DESCR ("cotangent")
	DESCR ("radians to degrees")
	DESCR ("degrees to radians")
	DESCR ("PI")
	DESCR ("convert first char to int4")
	DESCR ("replicate string n times")
	DESCR ("convert SQL99 regexp pattern to POSIX style")
	DESCR ("convert LIKE pattern to use backslash escapes")
	DESCR ("lowercase")
	DESCR ("uppercase")
	DESCR ("capitalize each word")
	DESCR ("left-pad string to length")
	DESCR ("right-pad string to length")
	DESCR ("trim selected characters from left end of string")
	DESCR ("trim selected characters from right end of string")
	DESCR ("extract portion of string")
	DESCR ("map a set of characters appearing in string")
	DESCR ("trim spaces from left end of string")
	DESCR ("trim spaces from right end of string")
	DESCR ("trim selected characters from both ends of string")
	DESCR ("trim spaces from both ends of string")
	DESCR ("replace all occurrences in string of old_substr with new_substr")
	DESCR ("replace text using regexp")
	DESCR ("find all match groups for regexp")
	DESCR ("split string by field_sep and return field_num")
	DESCR ("split string by pattern")
	DESCR ("convert int4 number to hex")
	DESCR ("convert int8 number to hex")
	DESCR ("encoding name of current database")
	DESCR ("length of string in specified encoding")
	DESCR ("convert string with specified source encoding name")
	DESCR ("convert string with specified destination encoding name")
	DESCR ("convert string with specified encoding names")
	DESCR ("convert encoding name to encoding id")
	DESCR ("convert encoding id to encoding name")
	DESCR ("maximum octet length of a character in given encoding")
	DESCR ("source text of a rule")
	DESCR ("select statement of a view")
	DESCR ("role name by OID (with fallback)")
	DESCR ("index description")
	DESCR ("trigger description")
	DESCR ("constraint description")
	DESCR ("deparse an encoded expression")
	DESCR ("name of sequence for a serial column")
	DESCR ("definition of a function")
	DESCR ("argument list of a function")
	DESCR ("identity argument list of a function")
	DESCR ("result type of a function")
	DESCR ("list of SQL keywords")
	DESCR ("convert generic options array to name/value table")
	DESCR ("type of the argument")
	DESCR ("collation of the argument; implementation of the COLLATION FOR expression")
	DESCR ("is a view insertable-into")
	DESCR ("is a view updatable")
	DESCR ("is a relation scannable")
	DESCR ("deferred UNIQUE constraint check")
	DESCR ("referential integrity FOREIGN KEY ... REFERENCES")
	DESCR ("referential integrity ON DELETE CASCADE")
	DESCR ("referential integrity ON UPDATE CASCADE")
	DESCR ("referential integrity ON DELETE RESTRICT")
	DESCR ("referential integrity ON UPDATE RESTRICT")
	DESCR ("referential integrity ON DELETE SET NULL")
	DESCR ("referential integrity ON UPDATE SET NULL")
	DESCR ("referential integrity ON DELETE SET DEFAULT")
	DESCR ("referential integrity ON UPDATE SET DEFAULT")
	DESCR ("referential integrity ON DELETE NO ACTION")
	DESCR ("referential integrity ON UPDATE NO ACTION")
	DESCR ("extract portion of bitstring")
	DESCR ("bitstring length")
	DESCR ("convert int4 to bitstring")
	DESCR ("convert bitstring to int4")
	DESCR ("adjust bit() to typmod length")
	DESCR ("transform a varbit length coercion")
	DESCR ("adjust varbit() to typmod length")
	DESCR ("position of sub-bitstring")
	DESCR ("substitute portion of bitstring")
	DESCR ("MAC manufacturer fields")
	DESCR ("abbreviated display of inet value")
	DESCR ("abbreviated display of cidr value")
	DESCR ("change netmask of inet")
	DESCR ("change netmask of cidr")
	DESCR ("address family (4 for IPv4, 6 for IPv6)")
	DESCR ("network part of address")
	DESCR ("netmask of address")
	DESCR ("netmask length")
	DESCR ("broadcast address of network")
	DESCR ("show address octets only")
	DESCR ("show all parts of inet/cidr value")
	DESCR ("hostmask of address")
	DESCR ("convert inet to cidr")
	DESCR ("inet address of the client")
	DESCR ("client's port number for this connection")
	DESCR ("inet address of the server")
	DESCR ("server's port number for this connection")
	DESCR ("transform a numeric length coercion")
	DESCR ("adjust numeric to typmod precision/scale")
	DESCR ("value rounded to 'scale'")
	DESCR ("value rounded to 'scale' of zero")
	DESCR ("value truncated to 'scale'")
	DESCR ("value truncated to 'scale' of zero")
	DESCR ("logarithm base m of n")
	DESCR ("convert int4 to numeric")
	DESCR ("convert float4 to numeric")
	DESCR ("convert float8 to numeric")
	DESCR ("convert numeric to int4")
	DESCR ("convert numeric to float4")
	DESCR ("convert numeric to float8")
	DESCR ("trunc(x/y)")
	DESCR ("increment by one")
	DESCR ("convert numeric to int8")
	DESCR ("convert int8 to numeric")
	DESCR ("convert int2 to numeric")
	DESCR ("convert numeric to int2")
	DESCR ("format timestamp with time zone to text")
	DESCR ("format numeric to text")
	DESCR ("format int4 to text")
	DESCR ("format int8 to text")
	DESCR ("format float4 to text")
	DESCR ("format float8 to text")
	DESCR ("convert text to numeric")
	DESCR ("convert text to timestamp with time zone")
	DESCR ("convert text to date")
	DESCR ("format interval to text")
	DESCR ("quote an identifier for usage in a querystring")
	DESCR ("quote a literal for usage in a querystring")
	DESCR ("quote a data value for usage in a querystring")
	DESCR ("quote a possibly-null literal for usage in a querystring")
	DESCR ("quote a possibly-null data value for usage in a querystring")
	DESCR ("concatenate values")
	DESCR ("concatenate values with separators")
	DESCR ("extract the first n characters")
	DESCR ("extract the last n characters")
	DESCR ("reverse text")
	DESCR ("format text message")
	DESCR ("length in bits")
	DESCR ("restriction selectivity of ILIKE")
	DESCR ("restriction selectivity of NOT ILIKE")
	DESCR ("join selectivity of ILIKE")
	DESCR ("join selectivity of NOT ILIKE")
	DESCR ("restriction selectivity of regex match")
	DESCR ("restriction selectivity of LIKE")
	DESCR ("restriction selectivity of case-insensitive regex match")
	DESCR ("restriction selectivity of regex non-match")
	DESCR ("restriction selectivity of NOT LIKE")
	DESCR ("restriction selectivity of case-insensitive regex non-match")
	DESCR ("join selectivity of regex match")
	DESCR ("join selectivity of LIKE")
	DESCR ("join selectivity of case-insensitive regex match")
	DESCR ("join selectivity of regex non-match")
	DESCR ("join selectivity of NOT LIKE")
	DESCR ("join selectivity of case-insensitive regex non-match")
	DESCR ("concatenate aggregate input into a string")
	DESCR ("concatenate aggregate input into a bytea")
	DESCR ("encode text from DB encoding to ASCII text")
	DESCR ("encode text from encoding to ASCII text")
	DESCR ("user privilege on relation by username, rel name")
	DESCR ("user privilege on relation by username, rel oid")
	DESCR ("user privilege on relation by user oid, rel name")
	DESCR ("user privilege on relation by user oid, rel oid")
	DESCR ("current user privilege on relation by rel name")
	DESCR ("current user privilege on relation by rel oid")
	DESCR ("user privilege on sequence by username, seq name")
	DESCR ("user privilege on sequence by username, seq oid")
	DESCR ("user privilege on sequence by user oid, seq name")
	DESCR ("user privilege on sequence by user oid, seq oid")
	DESCR ("current user privilege on sequence by seq name")
	DESCR ("current user privilege on sequence by seq oid")
	DESCR ("user privilege on column by username, rel name, col name")
	DESCR ("user privilege on column by username, rel name, col attnum")
	DESCR ("user privilege on column by user oid, rel name, col name")
	DESCR ("user privilege on column by user oid, rel name, col attnum")
	DESCR ("current user privilege on column by rel name, col name")
	DESCR ("current user privilege on column by rel name, col attnum")
	DESCR ("user privilege on any column by username, rel name")
	DESCR ("user privilege on any column by username, rel oid")
	DESCR ("user privilege on any column by user oid, rel name")
	DESCR ("user privilege on any column by user oid, rel oid")
	DESCR ("current user privilege on any column by rel name")
	DESCR ("current user privilege on any column by rel oid")
	DESCR ("statistics: number of scans done for table/index")
	DESCR ("statistics: number of tuples read by seqscan")
	DESCR ("statistics: number of tuples fetched by idxscan")
	DESCR ("statistics: number of tuples inserted")
	DESCR ("statistics: number of tuples updated")
	DESCR ("statistics: number of tuples deleted")
	DESCR ("statistics: number of tuples hot updated")
	DESCR ("statistics: number of live tuples")
	DESCR ("statistics: number of dead tuples")
	DESCR ("statistics: number of blocks fetched")
	DESCR ("statistics: number of blocks found in cache")
	DESCR ("statistics: last manual vacuum time for a table")
	DESCR ("statistics: last auto vacuum time for a table")
	DESCR ("statistics: last manual analyze time for a table")
	DESCR ("statistics: last auto analyze time for a table")
	DESCR ("statistics: number of manual vacuums for a table")
	DESCR ("statistics: number of auto vacuums for a table")
	DESCR ("statistics: number of manual analyzes for a table")
	DESCR ("statistics: number of auto analyzes for a table")
	DESCR ("statistics: currently active backend IDs")
	DESCR ("statistics: information about currently active backends")
	DESCR ("statistics: information about currently active replication")
	DESCR ("statistics: current backend PID")
	DESCR ("statistics: PID of backend")
	DESCR ("statistics: database ID of backend")
	DESCR ("statistics: user ID of backend")
	DESCR ("statistics: current query of backend")
	DESCR ("statistics: is backend currently waiting for a lock")
	DESCR ("statistics: start time for current query of backend")
	DESCR ("statistics: start time for backend's current transaction")
	DESCR ("statistics: start time for current backend session")
	DESCR ("statistics: address of client connected to backend")
	DESCR ("statistics: port number of client connected to backend")
	DESCR ("statistics: number of backends in database")
	DESCR ("statistics: transactions committed")
	DESCR ("statistics: transactions rolled back")
	DESCR ("statistics: blocks fetched for database")
	DESCR ("statistics: blocks found in cache for database")
	DESCR ("statistics: tuples returned for database")
	DESCR ("statistics: tuples fetched for database")
	DESCR ("statistics: tuples inserted in database")
	DESCR ("statistics: tuples updated in database")
	DESCR ("statistics: tuples deleted in database")
	DESCR ("statistics: recovery conflicts in database caused by drop tablespace")
	DESCR ("statistics: recovery conflicts in database caused by relation lock")
	DESCR ("statistics: recovery conflicts in database caused by snapshot expiry")
	DESCR ("statistics: recovery conflicts in database caused by shared buffer pin")
	DESCR ("statistics: recovery conflicts in database caused by buffer deadlock")
	DESCR ("statistics: recovery conflicts in database")
	DESCR ("statistics: deadlocks detected in database")
	DESCR ("statistics: last reset for a database")
	DESCR ("statistics: number of temporary files written")
	DESCR ("statistics: number of bytes in temporary files written")
	DESCR ("statistics: block read time, in msec")
	DESCR ("statistics: block write time, in msec")
	DESCR ("statistics: number of timed checkpoints started by the bgwriter")
	DESCR ("statistics: number of backend requested checkpoints started by the bgwriter")
	DESCR ("statistics: number of buffers written by the bgwriter during checkpoints")
	DESCR ("statistics: number of buffers written by the bgwriter for cleaning dirty buffers")
	DESCR ("statistics: number of times the bgwriter stopped processing when it had written too many buffers while cleaning")
	DESCR ("statistics: last reset for the bgwriter")
	DESCR ("statistics: checkpoint time spent writing buffers to disk, in msec")
	DESCR ("statistics: checkpoint time spent synchronizing buffers to disk, in msec")
	DESCR ("statistics: number of buffers written by backends")
	DESCR ("statistics: number of backend buffer writes that did their own fsync")
	DESCR ("statistics: number of buffer allocations")
	DESCR ("statistics: number of function calls")
	DESCR ("statistics: total execution time of function, in msec")
	DESCR ("statistics: self execution time of function, in msec")
	DESCR ("statistics: number of scans done for table/index in current transaction")
	DESCR ("statistics: number of tuples read by seqscan in current transaction")
	DESCR ("statistics: number of tuples fetched by idxscan in current transaction")
	DESCR ("statistics: number of tuples inserted in current transaction")
	DESCR ("statistics: number of tuples updated in current transaction")
	DESCR ("statistics: number of tuples deleted in current transaction")
	DESCR ("statistics: number of tuples hot updated in current transaction")
	DESCR ("statistics: number of blocks fetched in current transaction")
	DESCR ("statistics: number of blocks found in cache in current transaction")
	DESCR ("statistics: number of function calls in current transaction")
	DESCR ("statistics: total execution time of function in current transaction, in msec")
	DESCR ("statistics: self execution time of function in current transaction, in msec")
	DESCR ("statistics: discard current transaction's statistics snapshot")
	DESCR ("statistics: reset collected statistics for current database")
	DESCR ("statistics: reset collected statistics shared across the cluster")
	DESCR ("statistics: reset collected statistics for a single table or index in the current database")
	DESCR ("statistics: reset collected statistics for a single function in the current database")
	DESCR ("current trigger depth")
	DESCR ("tablespace location")
	DESCR ("convert bytea value into some ascii-only text string")
	DESCR ("convert ascii-encoded text string into bytea value")
	DESCR ("transform a timestamp length coercion")
	DESCR ("transform a time length coercion")
	DESCR ("adjust timestamp precision")
	DESCR ("adjust timestamptz precision")
	DESCR ("adjust time precision")
	DESCR ("adjust time with time zone precision")
	DESCR ("trim both ends of string")
	DESCR ("convert timestamp with time zone to time")
	DESCR ("truncate timestamp to specified units")
	DESCR ("extract field from timestamp")
	DESCR ("convert abstime to timestamp")
	DESCR ("convert date to timestamp")
	DESCR ("convert date and time to timestamp")
	DESCR ("convert timestamp with time zone to timestamp")
	DESCR ("convert timestamp to timestamp with time zone")
	DESCR ("convert timestamp to date")
	DESCR ("convert timestamp to abstime")
	DESCR ("adjust time with time zone to new zone")
	DESCR ("convert time with time zone to time")
	DESCR ("convert time to time with time zone")
	DESCR ("format timestamp to text")
	DESCR ("extract text matching regular expression")
	DESCR ("extract text matching SQL99 regular expression")
	DESCR ("convert int8 to bitstring")
	DESCR ("convert bitstring to int8")
	DESCR ("SHOW X as a function")
	DESCR ("SET X as a function")
	DESCR ("SHOW ALL as a function")
	DESCR ("view system lock information")
	DESCR ("view two-phase transactions")
	DESCR ("view members of a multixactid")
	DESCR ("get identification of SQL object")
	DESCR ("get machine-parseable identification of SQL object")
	DESCR ("is table visible in search path?")
	DESCR ("is type visible in search path?")
	DESCR ("is function visible in search path?")
	DESCR ("is operator visible in search path?")
	DESCR ("is opclass visible in search path?")
	DESCR ("is opfamily visible in search path?")
	DESCR ("is conversion visible in search path?")
	DESCR ("is text search parser visible in search path?")
	DESCR ("is text search dictionary visible in search path?")
	DESCR ("is text search template visible in search path?")
	DESCR ("is text search configuration visible in search path?")
	DESCR ("is collation visible in search path?")
	DESCR ("get OID of current session's temp schema, if any")
	DESCR ("is schema another session's temp schema?")
	DESCR ("cancel a server process' current query")
	DESCR ("terminate a server process")
	DESCR ("prepare for taking an online backup")
	DESCR ("finish taking an online backup")
	DESCR ("true if server is in online backup")
	DESCR ("start time of an online backup")
	DESCR ("switch to new xlog file")
	DESCR ("create a named restore point")
	DESCR ("current xlog write location")
	DESCR ("current xlog insert location")
	DESCR ("xlog filename and byte offset, given an xlog location")
	DESCR ("xlog filename, given an xlog location")
	DESCR ("difference in bytes, given two xlog locations")
	DESCR ("export a snapshot")
	DESCR ("true if server is in recovery")
	DESCR ("current xlog flush location")
	DESCR ("last xlog replay location")
	DESCR ("timestamp of last replay xact")
	DESCR ("pause xlog replay")
	DESCR ("resume xlog replay, if it was paused")
	DESCR ("true if xlog replay is paused")
	DESCR ("reload configuration files")
	DESCR ("rotate log file")
	DESCR ("get information about file")
	DESCR ("read text from a file")
	DESCR ("list all files in a directory")
	DESCR ("sleep for the specified time in seconds")
	DESCR ("convert boolean to text")
	DESCR ("the average (arithmetic mean) as numeric of all bigint values")
	DESCR ("the average (arithmetic mean) as numeric of all integer values")
	DESCR ("the average (arithmetic mean) as numeric of all smallint values")
	DESCR ("the average (arithmetic mean) as numeric of all numeric values")
	DESCR ("the average (arithmetic mean) as float8 of all float4 values")
	DESCR ("the average (arithmetic mean) as float8 of all float8 values")
	DESCR ("the average (arithmetic mean) as interval of all interval values")
	DESCR ("sum as numeric across all bigint input values")
	DESCR ("sum as bigint across all integer input values")
	DESCR ("sum as bigint across all smallint input values")
	DESCR ("sum as float4 across all float4 input values")
	DESCR ("sum as float8 across all float8 input values")
	DESCR ("sum as money across all money input values")
	DESCR ("sum as interval across all interval input values")
	DESCR ("sum as numeric across all numeric input values")
	DESCR ("maximum value of all bigint input values")
	DESCR ("maximum value of all integer input values")
	DESCR ("maximum value of all smallint input values")
	DESCR ("maximum value of all oid input values")
	DESCR ("maximum value of all float4 input values")
	DESCR ("maximum value of all float8 input values")
	DESCR ("maximum value of all abstime input values")
	DESCR ("maximum value of all date input values")
	DESCR ("maximum value of all time input values")
	DESCR ("maximum value of all time with time zone input values")
	DESCR ("maximum value of all money input values")
	DESCR ("maximum value of all timestamp input values")
	DESCR ("maximum value of all timestamp with time zone input values")
	DESCR ("maximum value of all interval input values")
	DESCR ("maximum value of all text input values")
	DESCR ("maximum value of all numeric input values")
	DESCR ("maximum value of all anyarray input values")
	DESCR ("maximum value of all bpchar input values")
	DESCR ("maximum value of all tid input values")
	DESCR ("minimum value of all bigint input values")
	DESCR ("minimum value of all integer input values")
	DESCR ("minimum value of all smallint input values")
	DESCR ("minimum value of all oid input values")
	DESCR ("minimum value of all float4 input values")
	DESCR ("minimum value of all float8 input values")
	DESCR ("minimum value of all abstime input values")
	DESCR ("minimum value of all date input values")
	DESCR ("minimum value of all time input values")
	DESCR ("minimum value of all time with time zone input values")
	DESCR ("minimum value of all money input values")
	DESCR ("minimum value of all timestamp input values")
	DESCR ("minimum value of all timestamp with time zone input values")
	DESCR ("minimum value of all interval input values")
	DESCR ("minimum value of all text values")
	DESCR ("minimum value of all numeric input values")
	DESCR ("minimum value of all anyarray input values")
	DESCR ("minimum value of all bpchar input values")
	DESCR ("minimum value of all tid input values")
	DESCR ("number of input rows for which the input expression is not null")
	DESCR ("number of input rows")
	DESCR ("population variance of bigint input values (square of the population standard deviation)")
	DESCR ("population variance of integer input values (square of the population standard deviation)")
	DESCR ("population variance of smallint input values (square of the population standard deviation)")
	DESCR ("population variance of float4 input values (square of the population standard deviation)")
	DESCR ("population variance of float8 input values (square of the population standard deviation)")
	DESCR ("population variance of numeric input values (square of the population standard deviation)")
	DESCR ("sample variance of bigint input values (square of the sample standard deviation)")
	DESCR ("sample variance of integer input values (square of the sample standard deviation)")
	DESCR ("sample variance of smallint input values (square of the sample standard deviation)")
	DESCR ("sample variance of float4 input values (square of the sample standard deviation)")
	DESCR ("sample variance of float8 input values (square of the sample standard deviation)")
	DESCR ("sample variance of numeric input values (square of the sample standard deviation)")
	DESCR ("historical alias for var_samp")
	DESCR ("population standard deviation of bigint input values")
	DESCR ("population standard deviation of integer input values")
	DESCR ("population standard deviation of smallint input values")
	DESCR ("population standard deviation of float4 input values")
	DESCR ("population standard deviation of float8 input values")
	DESCR ("population standard deviation of numeric input values")
	DESCR ("sample standard deviation of bigint input values")
	DESCR ("sample standard deviation of integer input values")
	DESCR ("sample standard deviation of smallint input values")
	DESCR ("sample standard deviation of float4 input values")
	DESCR ("sample standard deviation of float8 input values")
	DESCR ("sample standard deviation of numeric input values")
	DESCR ("historical alias for stddev_samp")
	DESCR ("number of input rows in which both expressions are not null")
	DESCR ("sum of squares of the independent variable (sum(X^2) - sum(X)^2/N)")
	DESCR ("sum of squares of the dependent variable (sum(Y^2) - sum(Y)^2/N)")
	DESCR ("sum of products of independent times dependent variable (sum(X*Y) - sum(X) * sum(Y)/N)")
	DESCR ("average of the independent variable (sum(X)/N)")
	DESCR ("average of the dependent variable (sum(Y)/N)")
	DESCR ("square of the correlation coefficient")
	DESCR ("slope of the least-squares-fit linear equation determined by the (X, Y) pairs")
	DESCR ("y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs")
	DESCR ("population covariance")
	DESCR ("sample covariance")
	DESCR ("correlation coefficient")
	DESCR ("convert text to regclass")
	DESCR ("(internal)")
	DESCR ("user privilege on database by username, database name")
	DESCR ("user privilege on database by username, database oid")
	DESCR ("user privilege on database by user oid, database name")
	DESCR ("user privilege on database by user oid, database oid")
	DESCR ("current user privilege on database by database name")
	DESCR ("current user privilege on database by database oid")
	DESCR ("user privilege on function by username, function name")
	DESCR ("user privilege on function by username, function oid")
	DESCR ("user privilege on function by user oid, function name")
	DESCR ("user privilege on function by user oid, function oid")
	DESCR ("current user privilege on function by function name")
	DESCR ("current user privilege on function by function oid")
	DESCR ("user privilege on language by username, language name")
	DESCR ("user privilege on language by username, language oid")
	DESCR ("user privilege on language by user oid, language name")
	DESCR ("user privilege on language by user oid, language oid")
	DESCR ("current user privilege on language by language name")
	DESCR ("current user privilege on language by language oid")
	DESCR ("user privilege on schema by username, schema name")
	DESCR ("user privilege on schema by username, schema oid")
	DESCR ("user privilege on schema by user oid, schema name")
	DESCR ("user privilege on schema by user oid, schema oid")
	DESCR ("current user privilege on schema by schema name")
	DESCR ("current user privilege on schema by schema oid")
	DESCR ("user privilege on tablespace by username, tablespace name")
	DESCR ("user privilege on tablespace by username, tablespace oid")
	DESCR ("user privilege on tablespace by user oid, tablespace name")
	DESCR ("user privilege on tablespace by user oid, tablespace oid")
	DESCR ("current user privilege on tablespace by tablespace name")
	DESCR ("current user privilege on tablespace by tablespace oid")
	DESCR ("user privilege on foreign data wrapper by username, foreign data wrapper name")
	DESCR ("user privilege on foreign data wrapper by username, foreign data wrapper oid")
	DESCR ("user privilege on foreign data wrapper by user oid, foreign data wrapper name")
	DESCR ("user privilege on foreign data wrapper by user oid, foreign data wrapper oid")
	DESCR ("current user privilege on foreign data wrapper by foreign data wrapper name")
	DESCR ("current user privilege on foreign data wrapper by foreign data wrapper oid")
	DESCR ("user privilege on server by username, server name")
	DESCR ("user privilege on server by username, server oid")
	DESCR ("user privilege on server by user oid, server name")
	DESCR ("user privilege on server by user oid, server oid")
	DESCR ("current user privilege on server by server name")
	DESCR ("current user privilege on server by server oid")
	DESCR ("user privilege on type by username, type name")
	DESCR ("user privilege on type by username, type oid")
	DESCR ("user privilege on type by user oid, type name")
	DESCR ("user privilege on type by user oid, type oid")
	DESCR ("current user privilege on type by type name")
	DESCR ("current user privilege on type by type oid")
	DESCR ("user privilege on role by username, role name")
	DESCR ("user privilege on role by username, role oid")
	DESCR ("user privilege on role by user oid, role name")
	DESCR ("user privilege on role by user oid, role oid")
	DESCR ("current user privilege on role by role name")
	DESCR ("current user privilege on role by role oid")
	DESCR ("bytes required to store the value, perhaps with compression")
	DESCR ("total disk space usage for the specified tablespace")
	DESCR ("total disk space usage for the specified database")
	DESCR ("disk space usage for the main fork of the specified table or index")
	DESCR ("disk space usage for the specified fork of a table or index")
	DESCR ("total disk space usage for the specified table and associated indexes")
	DESCR ("convert a long int to a human readable text using size units")
	DESCR ("convert a numeric to a human readable text using size units")
	DESCR ("disk space usage for the specified table, including TOAST, free space and visibility map")
	DESCR ("disk space usage for all indexes attached to the specified table")
	DESCR ("filenode identifier of relation")
	DESCR ("file path of relation")
	DESCR ("MD5 hash")
	DESCR ("source text of a rule with pretty-print option")
	DESCR ("select statement of a view with pretty-print option")
	DESCR ("select statement of a view with pretty-printing and specified line wrapping")
	DESCR ("index description (full create statement or single expression) with pretty-print option")
	DESCR ("constraint description with pretty-print option")
	DESCR ("deparse an encoded expression with pretty-print option")
	DESCR ("get the prepared statements for this session")
	DESCR ("get the open cursors for this session")
	DESCR ("get the available time zone abbreviations")
	DESCR ("get the available time zone names")
	DESCR ("trigger description with pretty-print option")
	DESCR ("get the channels that the current backend listens to")
	DESCR ("send a notification event")
	DESCR ("non-persistent series generator")
	DESCR ("boolean-and aggregate")
	DESCR ("boolean-or aggregate")
	DESCR ("bitwise-and smallint aggregate")
	DESCR ("bitwise-or smallint aggregate")
	DESCR ("bitwise-and integer aggregate")
	DESCR ("bitwise-or integer aggregate")
	DESCR ("bitwise-and bigint aggregate")
	DESCR ("bitwise-or bigint aggregate")
	DESCR ("bitwise-and bit aggregate")
	DESCR ("bitwise-or bit aggregate")
	DESCR ("get OIDs of databases in a tablespace")
	DESCR ("convert int4 to boolean")
	DESCR ("convert boolean to int4")
	DESCR ("current value from last used sequence")
	DESCR ("postmaster start time")
	DESCR ("configuration load time")
	DESCR ("GiST support")
	DESCR ("gin(internal)")
	DESCR ("GIN array support")
	DESCR ("GIN array support (obsolete)")
	DESCR ("obtain exclusive advisory lock")
	DESCR ("obtain shared advisory lock")
	DESCR ("obtain exclusive advisory lock if available")
	DESCR ("obtain shared advisory lock if available")
	DESCR ("release exclusive advisory lock")
	DESCR ("release shared advisory lock")
	DESCR ("release all advisory locks")
	DESCR ("generate XML comment")
	DESCR ("perform a non-validating parse of a character string to produce an XML value")
	DESCR ("validate an XML value")
	DESCR ("concatenate XML values")
	DESCR ("serialize an XML value to a character string")
	DESCR ("map table contents to XML")
	DESCR ("map query result to XML")
	DESCR ("map rows from cursor to XML")
	DESCR ("map table structure to XML Schema")
	DESCR ("map query result structure to XML Schema")
	DESCR ("map cursor structure to XML Schema")
	DESCR ("map table contents and structure to XML and XML Schema")
	DESCR ("map query result and structure to XML and XML Schema")
	DESCR ("map schema contents to XML")
	DESCR ("map schema structure to XML Schema")
	DESCR ("map schema contents and structure to XML and XML Schema")
	DESCR ("map database contents to XML")
	DESCR ("map database structure to XML Schema")
	DESCR ("map database contents and structure to XML and XML Schema")
	DESCR ("evaluate XPath expression, with namespaces support")
	DESCR ("evaluate XPath expression")
	DESCR ("test XML value against XPath expression")
	DESCR ("test XML value against XPath expression, with namespace support")
	DESCR ("determine if a string is well formed XML")
	DESCR ("determine if a string is well formed XML document")
	DESCR ("determine if a string is well formed XML content")
	DESCR ("map array to json")
	DESCR ("map array to json with optional pretty printing")
	DESCR ("map row to json")
	DESCR ("map row to json with optional pretty printing")
	DESCR ("json aggregate transition function")
	DESCR ("json aggregate final function")
	DESCR ("aggregate input into json")
	DESCR ("map input to json")
	DESCR ("get json object field")
	DESCR ("get json object field as text")
	DESCR ("get json array element")
	DESCR ("get json array element as text")
	DESCR ("get value from json with path elements")
	DESCR ("get value from json as text with path elements")
	DESCR ("key value pairs of a json object")
	DESCR ("length of json array")
	DESCR ("get json object keys")
	DESCR ("get record fields from a json object")
	DESCR ("get set of records with fields from a json array of objects")
	DESCR ("maximum value of all enum input values")
	DESCR ("minimum value of all enum input values")
	DESCR ("first value of the input enum type")
	DESCR ("last value of the input enum type")
	DESCR ("range between the two given enum values, as an ordered array")
	DESCR ("range of the given enum type, as an ordered array")
	DESCR ("number of lexemes")
	DESCR ("strip position information")
	DESCR ("set weight of lexeme's entries")
	DESCR ("GiST tsvector support")
	DESCR ("GIN tsvector support")
	DESCR ("GIN tsvector support (obsolete)")
	DESCR ("number of nodes")
	DESCR ("show real useful query for GiST index")
	DESCR ("rewrite tsquery")
	DESCR ("GiST tsquery support")
	DESCR ("restriction selectivity of tsvector @@ tsquery")
	DESCR ("join selectivity of tsvector @@ tsquery")
	DESCR ("tsvector typanalyze")
	DESCR ("statistics of tsvector column")
	DESCR ("relevance")
	DESCR ("get parser's token types")
	DESCR ("parse text to tokens")
	DESCR ("normalize one word by dictionary")
	DESCR ("generate headline")
	DESCR ("transform to tsvector")
	DESCR ("make tsquery")
	DESCR ("transform to tsquery")
	DESCR ("trigger for automatic update of tsvector column")
	DESCR ("get current tsearch configuration")
	DESCR ("get current transaction ID")
	DESCR ("get current snapshot")
	DESCR ("get xmin of snapshot")
	DESCR ("get xmax of snapshot")
	DESCR ("get set of in-progress txids in snapshot")
	DESCR ("is txid visible in snapshot?")
	DESCR ("list available extensions")
	DESCR ("list available extension versions")
	DESCR ("list an extension's version update paths")
	DESCR ("flag an extension's table contents to be emitted by pg_dump")
	DESCR ("row number within partition")
	DESCR ("integer rank with gaps")
	DESCR ("integer rank without gaps")
	DESCR ("fractional rank within partition")
	DESCR ("fractional row number within partition")
	DESCR ("split rows into N groups")
	DESCR ("fetch the preceding row value")
	DESCR ("fetch the Nth preceding row value")
	DESCR ("fetch the Nth preceding row value with default")
	DESCR ("fetch the following row value")
	DESCR ("fetch the Nth following row value")
	DESCR ("fetch the Nth following row value with default")
	DESCR ("fetch the first row value")
	DESCR ("fetch the last row value")
	DESCR ("fetch the Nth row value")
	DESCR ("lower bound of range")
	DESCR ("upper bound of range")
	DESCR ("is the range empty?")
	DESCR ("is the range's lower bound inclusive?")
	DESCR ("is the range's upper bound inclusive?")
	DESCR ("is the range's lower bound infinite?")
	DESCR ("is the range's upper bound infinite?")
	DESCR ("implementation of <> operator")
	DESCR ("implementation of && operator")
	DESCR ("implementation of @> operator")
	DESCR ("implementation of -|- operator")
	DESCR ("implementation of << operator")
	DESCR ("implementation of >> operator")
	DESCR ("implementation of &> operator")
	DESCR ("implementation of + operator")
	DESCR ("implementation of * operator")
	DESCR ("implementation of - operator")
	DESCR ("hash a range")
	DESCR ("range typanalyze")
	DESCR ("restriction selectivity for range operators")
	DESCR ("convert an int4 range to canonical form")
	DESCR ("convert an int8 range to canonical form")
	DESCR ("convert a date range to canonical form")
	DESCR ("float8 difference of two int4 values")
	DESCR ("float8 difference of two int8 values")
	DESCR ("float8 difference of two numeric values")
	DESCR ("float8 difference of two date values")
	DESCR ("float8 difference of two timestamp values")
	DESCR ("float8 difference of two timestamp with time zone values")
	DESCR ("int4range constructor")
	DESCR ("numrange constructor")
	DESCR ("tsrange constructor")
	DESCR ("tstzrange constructor")
	DESCR ("daterange constructor")
	DESCR ("int8range constructor")
	DESCR ("spgist(internal)")
	DESCR ("SP-GiST support for quad tree over point")
	DESCR ("SP-GiST support for quad tree and k-d tree over point")
	DESCR ("SP-GiST support for k-d tree over point")
	DESCR ("SP-GiST support for suffix tree over text")
	DESCR ("SP-GiST support for quad tree over range")
	DESCR ("list objects dropped by the current command")
Variables
	FormData_pg_proc

---

Define Documentation

#define Anum_pg_proc_proacl   27

Definition at line 114 of file pg_proc.h.

Referenced by ExecGrant_Function(), pg_proc_aclmask(), and ProcedureCreate().

#define Anum_pg_proc_proallargtypes   20

Definition at line 107 of file pg_proc.h.

Referenced by build_function_result_tupdesc_t(), get_func_arg_info(), and ProcedureCreate().

#define Anum_pg_proc_proargdefaults   23

Definition at line 110 of file pg_proc.h.

Referenced by fetch_function_defaults(), func_get_detail(), print_function_arguments(), and ProcedureCreate().

#define Anum_pg_proc_proargmodes   21

Definition at line 108 of file pg_proc.h.

Referenced by build_function_result_tupdesc_t(), get_func_arg_info(), get_func_result_name(), prepare_sql_fn_parse_info(), and ProcedureCreate().

#define Anum_pg_proc_proargnames   22

Definition at line 109 of file pg_proc.h.

Referenced by build_function_result_tupdesc_t(), get_func_arg_info(), get_func_result_name(), MatchNamedCall(), prepare_sql_fn_parse_info(), and ProcedureCreate().

#define Anum_pg_proc_proargtypes   19

Definition at line 106 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_probin   25

Definition at line 112 of file pg_proc.h.

Referenced by fmgr_c_validator(), fmgr_info_C_lang(), pg_get_functiondef(), and ProcedureCreate().

#define Anum_pg_proc_proconfig   26

Definition at line 113 of file pg_proc.h.

Referenced by AlterFunction(), fmgr_info_cxt_security(), fmgr_security_definer(), inline_function(), inline_set_returning_function(), pg_get_functiondef(), and ProcedureCreate().

#define Anum_pg_proc_procost   5

Definition at line 92 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_proisagg   9

Definition at line 96 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_proisstrict   13

Definition at line 100 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_proiswindow   10

Definition at line 97 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_prolang   4

Definition at line 91 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_proleakproof   12

Definition at line 99 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_proname   1

Definition at line 88 of file pg_proc.h.

Referenced by ProcedureCreate(), and regprocin().

#define Anum_pg_proc_pronamespace   2

Definition at line 89 of file pg_proc.h.

Referenced by objectsInSchemaToOids(), and ProcedureCreate().

#define Anum_pg_proc_pronargdefaults   17

Definition at line 104 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_pronargs   16

Definition at line 103 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_proowner   3

Definition at line 90 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_proretset   14

Definition at line 101 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_prorettype   18

Definition at line 105 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_prorows   6

Definition at line 93 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_prosecdef   11

Definition at line 98 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_prosrc   24

Definition at line 111 of file pg_proc.h.

Referenced by compile_plperl_function(), compile_pltcl_function(), do_compile(), fmgr_c_validator(), fmgr_info_C_lang(), fmgr_info_cxt_security(), fmgr_internal_validator(), fmgr_sql_validator(), init_sql_fcache(), inline_function(), inline_set_returning_function(), pg_get_functiondef(), PLy_procedure_create(), and ProcedureCreate().

#define Anum_pg_proc_protransform   8

Definition at line 95 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_provariadic   7

Definition at line 94 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Anum_pg_proc_provolatile   15

Definition at line 102 of file pg_proc.h.

Referenced by ProcedureCreate().

#define Natts_pg_proc   27

Definition at line 87 of file pg_proc.h.

Referenced by RelationCacheInitializePhase3().

#define PROARGMODE_IN   'i'

Definition at line 4747 of file pg_proc.h.

Referenced by build_function_result_tupdesc_d(), do_compile(), format_function_arguments_old(), get_func_input_arg_names(), get_func_result_name(), print_function_arguments(), and ProcedureCreate().

#define PROARGMODE_INOUT   'b'

Definition at line 4749 of file pg_proc.h.

Referenced by build_function_result_tupdesc_d(), do_compile(), format_function_arguments_old(), get_func_input_arg_names(), get_func_result_name(), print_function_arguments(), and ProcedureCreate().

#define PROARGMODE_OUT   'o'

Definition at line 4748 of file pg_proc.h.

Referenced by build_function_result_tupdesc_d(), do_compile(), format_function_arguments_old(), get_func_result_name(), PLy_procedure_create(), print_function_arguments(), ProcedureCreate(), and resolve_polymorphic_argtypes().

#define PROARGMODE_TABLE   't'

Definition at line 4751 of file pg_proc.h.

Referenced by build_function_result_tupdesc_d(), do_compile(), get_func_result_name(), PLy_procedure_create(), print_function_arguments(), ProcedureCreate(), and resolve_polymorphic_argtypes().

#define PROARGMODE_VARIADIC   'v'

Definition at line 4750 of file pg_proc.h.

Referenced by build_function_result_tupdesc_d(), do_compile(), get_func_input_arg_names(), get_func_result_name(), print_function_arguments(), and ProcedureCreate().

#define ProcedureRelation_Rowtype_Id   81

Definition at line 34 of file pg_proc.h.

Referenced by RelationCacheInitializePhase3().

#define ProcedureRelationId   1255

Definition at line 33 of file pg_proc.h.

Referenced by AlterForeignDataWrapper(), AlterFunction(), AlterObjectNamespace_internal(), AlterObjectRename_internal(), CheckSetNamespace(), exec_object_restorecon(), ExecGrant_Function(), getObjectClass(), objectsInSchemaToOids(), pgstat_vacuum_stat(), ProcedureCreate(), regprocin(), RelationBuildLocalRelation(), RemoveFunctionById(), RemoveRoleFromObjectACL(), sepgsql_object_access(), sepgsql_object_relabel(), sepgsql_proc_post_create(), sepgsql_proc_setattr(), sepgsql_restorecon(), SetFunctionArgType(), SetFunctionReturnType(), and shdepReassignOwned().

#define PROVOLATILE_IMMUTABLE   'i'

Definition at line 4738 of file pg_proc.h.

Referenced by AggregateCreate(), compute_attributes_with_style(), contain_mutable_functions_walker(), dumpFunc(), eval_const_expressions_mutator(), evaluate_function(), findRangeCanonicalFunction(), findRangeSubtypeDiffFunction(), get_btree_test_op(), inline_function(), makeRangeConstructors(), and pg_get_functiondef().

#define PROVOLATILE_STABLE   's'

Definition at line 4739 of file pg_proc.h.

Referenced by dumpFunc(), evaluate_function(), inline_function(), and pg_get_functiondef().

#define PROVOLATILE_VOLATILE   'v'

Definition at line 4740 of file pg_proc.h.

Referenced by contain_volatile_functions_walker(), CreateCast(), CreateProceduralLanguage(), dumpFunc(), inline_set_returning_function(), and pg_get_functiondef().

---

Typedef Documentation

typedef FormData_pg_proc* Form_pg_proc

Definition at line 81 of file pg_proc.h.

---

Function Documentation

CATALOG	(	pg_proc	,
		1255
	)

Definition at line 36 of file pg_proc.h.

{
    NameData    proname;        /* procedure name */
    Oid         pronamespace;   /* OID of namespace containing this proc */
    Oid         proowner;       /* procedure owner */
    Oid         prolang;        /* OID of pg_language entry */
    float4      procost;        /* estimated execution cost */
    float4      prorows;        /* estimated # of rows out (if proretset) */
    Oid         provariadic;    /* element type of variadic array, or 0 */
    regproc     protransform;   /* transforms calls to it during planning */
    bool        proisagg;       /* is it an aggregate? */
    bool        proiswindow;    /* is it a window function? */
    bool        prosecdef;      /* security definer */
    bool        proleakproof;   /* is it a leak-proof function? */
    bool        proisstrict;    /* strict with respect to NULLs? */
    bool        proretset;      /* returns a set? */
    char        provolatile;    /* see PROVOLATILE_ categories below */
    int16       pronargs;       /* number of arguments */
    int16       pronargdefaults;    /* number of arguments with defaults */
    Oid         prorettype;     /* OID of result type */

    /*
     * variable-length fields start here, but we allow direct access to
     * proargtypes
     */
    oidvector   proargtypes;    /* parameter types (excludes OUT params) */

#ifdef CATALOG_VARLEN
    Oid         proallargtypes[1];      /* all param types (NULL if IN only) */
    char        proargmodes[1]; /* parameter modes (NULL if IN only) */
    text        proargnames[1]; /* parameter names (NULL if no names) */
    pg_node_tree proargdefaults;/* list of expression trees for argument
                                 * defaults (NULL if none) */
    text        prosrc;         /* procedure source text */
    text        probin;         /* secondary procedure info (can be NULL) */
    text        proconfig[1];   /* procedure-local GUC settings */
    aclitem     proacl[1];      /* access permissions */
#endif
} FormData_pg_proc;

DATA

(

insert

OID = 1242(boolinPGNSP PGUID 12 1 0 0 0 f f f f t f i 1 0 16"2275"_null_ _null_ _null_ _null_ boolin _null_ _null_ _null_)

)

DESCR

(

"SP-GiST support for quad tree over range"

)

DESCR

(

"SP-GiST support for suffix tree over text"

)

DESCR

(

"SP-GiST support for k-d tree over point"

)

DESCR

(

"SP-GiST support for quad tree and k-d tree over point"

)

DESCR

(

"SP-GiST support for quad tree over point"

)

DESCR

(

"spgist(internal)"

)

DESCR

(

"int8range constructor"

)

DESCR

(

"daterange constructor"

)

DESCR

(

"tstzrange constructor"

)

DESCR

(

"tsrange constructor"

)

DESCR

(

"numrange constructor"

)

DESCR

(

"int4range constructor"

)

DESCR

(

"float8 difference of two timestamp with time zone values"

)

DESCR

(

"float8 difference of two timestamp values"

)

DESCR

(

"float8 difference of two date values"

)

DESCR

(

"float8 difference of two numeric values"

)

DESCR

(

"float8 difference of two int8 values"

)

DESCR

(

"float8 difference of two int4 values"

)

DESCR

(

"convert a date range to canonical form"

)

DESCR

(

"convert an int8 range to canonical form"

)

DESCR

(

"convert an int4 range to canonical form"

)

DESCR

(

"restriction selectivity for range operators"

)

DESCR

(

"range typanalyze"

)

DESCR

(

"hash a range"

)

DESCR

(

"implementation of - operator"

)

DESCR

(

"implementation of * operator"

)

DESCR

(

"implementation of + operator"

)

DESCR	(	"implementation of &	,
		operator"
	)

DESCR

(

"implementation of >> operator"

)

DESCR

(

"implementation of << operator"

)

DESCR

(

"implementation of -|- operator"

)

DESCR	(	"implementation of @	,
		operator"
	)

DESCR

(

"implementation of && operator"

)

DESCR

(

"implementation of <> operator"

)

DESCR

(

"is the range's upper bound infinite?"

)

DESCR

(

"is the range's lower bound infinite?"

)

DESCR

(

"is the range's upper bound inclusive?"

)

DESCR

(

"is the range's lower bound inclusive?"

)

DESCR

(

"is the range empty?"

)

DESCR

(

"upper bound of range"

)

DESCR

(

"lower bound of range"

)

DESCR

(

"fetch the Nth row value"

)

DESCR

(

"fetch the last row value"

)

DESCR

(

"fetch the first row value"

)

DESCR

(

"fetch the Nth following row value with default"

)

DESCR

(

"fetch the Nth following row value"

)

DESCR

(

"fetch the following row value"

)

DESCR

(

"fetch the Nth preceding row value with default"

)

DESCR

(

"fetch the Nth preceding row value"

)

DESCR

(

"fetch the preceding row value"

)

DESCR

(

"split rows into N groups"

)

DESCR

(

"fractional row number within partition"

)

DESCR

(

"fractional rank within partition"

)

DESCR

(

"integer rank without gaps"

)

DESCR

(

"integer rank with gaps"

)

DESCR

(

"row number within partition"

)

DESCR

(

"flag an extension's table contents to be emitted by pg_dump"

)

DESCR

(

"list an extension's version update paths"

)

DESCR

(

"list available extension versions"

)

DESCR

(

"list available extensions"

)

DESCR

(

"is txid visible in snapshot?"

)

DESCR

(

"get set of in-progress txids in snapshot"

)

DESCR

(

"get xmax of snapshot"

)

DESCR

(

"get xmin of snapshot"

)

DESCR

(

"get current snapshot"

)

DESCR

(

"get current transaction ID"

)

DESCR

(

"get current tsearch configuration"

)

DESCR

(

"trigger for automatic update of tsvector column"

)

DESCR

(

"transform to tsquery"

)

DESCR

(

"make tsquery"

)

DESCR

(

"transform to tsvector"

)

DESCR

(

"generate headline"

)

DESCR

(

"normalize one word by dictionary"

)

DESCR

(

"parse text to tokens"

)

DESCR

(

"get parser's token types"

)

DESCR

(

"relevance"

)

DESCR

(

"statistics of tsvector column"

)

DESCR

(

"tsvector typanalyze"

)

DESCR

(

"join selectivity of tsvector @@ tsquery"

)

DESCR

(

"restriction selectivity of tsvector @@ tsquery"

)

DESCR

(

"GiST tsquery support"

)

DESCR

(

"rewrite tsquery"

)

DESCR

(

"show real useful query for GiST index"

)

DESCR

(

"number of nodes"

)

DESCR

(

"GIN tsvector support (obsolete)"

)

DESCR

(

"GIN tsvector support"

)

DESCR

(

"GiST tsvector support"

)

DESCR

(

"set weight of lexeme's entries"

)

DESCR

(

"strip position information"

)

DESCR

(

"number of lexemes"

)

DESCR	(	"range of the given enum	type,
		as an ordered array"
	)

DESCR	(	"range between the two given enum	values,
		as an ordered array"
	)

DESCR

(

"last value of the input enum type"

)

DESCR

(

"first value of the input enum type"

)

DESCR

(

"minimum value of all enum input values"

)

DESCR

(

"maximum value of all enum input values"

)

DESCR

(

"get set of records with fields from a json array of objects"

)

DESCR

(

"get record fields from a json object"

)

DESCR

(

"get json object keys"

)

DESCR

(

"length of json array"

)

DESCR

(

"key value pairs of a json object"

)

DESCR

(

"get value from json as text with path elements"

)

DESCR

(

"get value from json with path elements"

)

DESCR

(

"get json array element as text"

)

DESCR

(

"get json array element"

)

DESCR

(

"get json object field as text"

)

DESCR

(

"get json object field"

)

DESCR

(

"map input to json"

)

DESCR

(

"aggregate input into json"

)

DESCR

(

"json aggregate final function"

)

DESCR

(

"json aggregate transition function"

)

DESCR

(

"map row to json with optional pretty printing"

)

DESCR

(

"map row to json"

)

DESCR

(

"map array to json with optional pretty printing"

)

DESCR

(

"map array to json"

)

DESCR

(

"determine if a string is well formed XML content"

)

DESCR

(

"determine if a string is well formed XML document"

)

DESCR

(

"determine if a string is well formed XML"

)

DESCR	(	"test XML value against XPath	expression,
		with namespace support"
	)

DESCR

(

"test XML value against XPath expression"

)

DESCR

(

"evaluate XPath expression"

)

DESCR	(	"evaluate XPath	expression,
		with namespaces support"
	)

DESCR

(

"map database contents and structure to XML and XML Schema"

)

DESCR

(

"map database structure to XML Schema"

)

DESCR

(

"map database contents to XML"

)

DESCR

(

"map schema contents and structure to XML and XML Schema"

)

DESCR

(

"map schema structure to XML Schema"

)

DESCR

(

"map schema contents to XML"

)

DESCR

(

"map query result and structure to XML and XML Schema"

)

DESCR

(

"map table contents and structure to XML and XML Schema"

)

DESCR

(

"map cursor structure to XML Schema"

)

DESCR

(

"map query result structure to XML Schema"

)

DESCR

(

"map table structure to XML Schema"

)

DESCR

(

"map rows from cursor to XML"

)

DESCR

(

"map query result to XML"

)

DESCR

(

"map table contents to XML"

)

DESCR

(

"serialize an XML value to a character string"

)

DESCR

(

"concatenate XML values"

)

DESCR

(

"validate an XML value"

)

DESCR

(

"perform a non-validating parse of a character string to produce an XML value"

)

DESCR

(

"generate XML comment"

)

DESCR

(

"release all advisory locks"

)

DESCR

(

"release shared advisory lock"

)

DESCR

(

"release exclusive advisory lock"

)

DESCR

(

"obtain shared advisory lock if available"

)

DESCR

(

"obtain exclusive advisory lock if available"

)

DESCR

(

"obtain shared advisory lock"

)

DESCR

(

"obtain exclusive advisory lock"

)

DESCR

(

"GIN array support (obsolete)"

)

DESCR

(

"GIN array support"

)

DESCR

(

"gin(internal)"

)

DESCR

(

"GiST support"

)

DESCR

(

"configuration load time"

)

DESCR

(

"postmaster start time"

)

DESCR

(

"current value from last used sequence"

)

DESCR

(

"convert boolean to int4"

)

DESCR

(

"convert int4 to boolean"

)

DESCR

(

"get OIDs of databases in a tablespace"

)

DESCR

(

"bitwise-or bit aggregate"

)

DESCR

(

"bitwise-and bit aggregate"

)

DESCR

(

"bitwise-or bigint aggregate"

)

DESCR

(

"bitwise-and bigint aggregate"

)

DESCR

(

"bitwise-or integer aggregate"

)

DESCR

(

"bitwise-and integer aggregate"

)

DESCR

(

"bitwise-or smallint aggregate"

)

DESCR

(

"bitwise-and smallint aggregate"

)

DESCR

(

"boolean-or aggregate"

)

DESCR

(

"boolean-and aggregate"

)

DESCR

(

"non-persistent series generator"

)

DESCR

(

"send a notification event"

)

DESCR

(

"get the channels that the current backend listens to"

)

DESCR

(

"trigger description with pretty-print option"

)

DESCR

(

"get the available time zone names"

)

DESCR

(

"get the available time zone abbreviations"

)

DESCR

(

"get the open cursors for this session"

)

DESCR

(

"get the prepared statements for this session"

)

DESCR

(

"deparse an encoded expression with pretty-print option"

)

DESCR

(

"constraint description with pretty-print option"

)

DESCR

(

"index description (full create statement or single expression) with pretty-print option"

)

DESCR

(

"select statement of a view with pretty-printing and specified line wrapping"

)

DESCR

(

"select statement of a view with pretty-print option"

)

DESCR

(

"source text of a rule with pretty-print option"

)

DESCR

(

"MD5 hash"

)

DESCR

(

"file path of relation"

)

DESCR

(

"filenode identifier of relation"

)

DESCR

(

"disk space usage for all indexes attached to the specified table"

)

DESCR	(	"disk space usage for the specified	table,
		including	TOAST,
		free space and visibility map"
	)

DESCR

(

"convert a numeric to a human readable text using size units"

)

DESCR

(

"convert a long int to a human readable text using size units"

)

DESCR

(

"total disk space usage for the specified table and associated indexes"

)

DESCR

(

"disk space usage for the specified fork of a table or index"

)

DESCR

(

"disk space usage for the main fork of the specified table or index"

)

DESCR

(

"total disk space usage for the specified database"

)

DESCR

(

"total disk space usage for the specified tablespace"

)

DESCR	(	"bytes required to store the	value,
		perhaps with compression"
	)

DESCR

(

"current user privilege on role by role oid"

)

DESCR

(

"current user privilege on role by role name"

)

DESCR	(	"user privilege on role by user	oid,
		role oid"
	)

DESCR	(	"user privilege on role by user	oid,
		role name"
	)

DESCR	(	"user privilege on role by	username,
		role oid"
	)

DESCR	(	"user privilege on role by	username,
		role name"
	)

DESCR

(

"current user privilege on type by type oid"

)

DESCR

(

"current user privilege on type by type name"

)

DESCR	(	"user privilege on type by user	oid,
		type oid"
	)

DESCR	(	"user privilege on type by user	oid,
		type name"
	)

DESCR	(	"user privilege on type by	username,
		type oid"
	)

DESCR	(	"user privilege on type by	username,
		type name"
	)

DESCR

(

"current user privilege on server by server oid"

)

DESCR

(

"current user privilege on server by server name"

)

DESCR	(	"user privilege on server by user	oid,
		server oid"
	)

DESCR	(	"user privilege on server by user	oid,
		server name"
	)

DESCR	(	"user privilege on server by	username,
		server oid"
	)

DESCR	(	"user privilege on server by	username,
		server name"
	)

DESCR

(

"current user privilege on foreign data wrapper by foreign data wrapper oid"

)

DESCR

(

"current user privilege on foreign data wrapper by foreign data wrapper name"

)

DESCR	(	"user privilege on foreign data wrapper by user	oid,
		foreign data wrapper oid"
	)

DESCR	(	"user privilege on foreign data wrapper by user	oid,
		foreign data wrapper name"
	)

DESCR	(	"user privilege on foreign data wrapper by	username,
		foreign data wrapper oid"
	)

DESCR	(	"user privilege on foreign data wrapper by	username,
		foreign data wrapper name"
	)

DESCR

(

"current user privilege on tablespace by tablespace oid"

)

DESCR

(

"current user privilege on tablespace by tablespace name"

)

DESCR	(	"user privilege on tablespace by user	oid,
		tablespace oid"
	)

DESCR	(	"user privilege on tablespace by user	oid,
		tablespace name"
	)

DESCR	(	"user privilege on tablespace by	username,
		tablespace oid"
	)

DESCR	(	"user privilege on tablespace by	username,
		tablespace name"
	)

DESCR

(

"current user privilege on schema by schema oid"

)

DESCR

(

"current user privilege on schema by schema name"

)

DESCR	(	"user privilege on schema by user	oid,
		schema oid"
	)

DESCR	(	"user privilege on schema by user	oid,
		schema name"
	)

DESCR	(	"user privilege on schema by	username,
		schema oid"
	)

DESCR	(	"user privilege on schema by	username,
		schema name"
	)

DESCR

(

"current user privilege on language by language oid"

)

DESCR

(

"current user privilege on language by language name"

)

DESCR	(	"user privilege on language by user	oid,
		language oid"
	)

DESCR	(	"user privilege on language by user	oid,
		language name"
	)

DESCR	(	"user privilege on language by	username,
		language oid"
	)

DESCR	(	"user privilege on language by	username,
		language name"
	)

DESCR

(

"current user privilege on function by function oid"

)

DESCR

(

"current user privilege on function by function name"

)

DESCR	(	"user privilege on function by user	oid,
		function oid"
	)

DESCR	(	"user privilege on function by user	oid,
		function name"
	)

DESCR	(	"user privilege on function by	username,
		function oid"
	)

DESCR	(	"user privilege on function by	username,
		function name"
	)

DESCR

(

"current user privilege on database by database oid"

)

DESCR

(

"current user privilege on database by database name"

)

DESCR	(	"user privilege on database by user	oid,
		database oid"
	)

DESCR	(	"user privilege on database by user	oid,
		database name"
	)

DESCR	(	"user privilege on database by	username,
		database oid"
	)

DESCR	(	"user privilege on database by	username,
		database name"
	)

DESCR

(

"(internal)"

)

DESCR

(

"convert text to regclass"

)

DESCR

(

"correlation coefficient"

)

DESCR

(

"sample covariance"

)

DESCR

(

"population covariance"

)

DESCR

(

"y-intercept of the least-squares-fit linear equation determined by the (X, Y) pairs"

)

DESCR

(

"slope of the least-squares-fit linear equation determined by the (X, Y) pairs"

)

DESCR

(

"square of the correlation coefficient"

)

DESCR

(

"average of the dependent variable (sum(Y)/N)"

)

DESCR

(

"average of the independent variable (sum(X)/N)"

)

DESCR

(

"sum of products of independent times dependent variable (sum(X*Y) - sum(X) * sum(Y)/N)"

)

DESCR

(

"sum of squares of the dependent variable (sum(Y^2) - sum(Y)^2/N)"

)

DESCR

(

"sum of squares of the independent variable (sum(X^2) - sum(X)^2/N)"

)

DESCR

(

"number of input rows in which both expressions are not null"

)

DESCR

(

"historical alias for stddev_samp"

)

DESCR

(

"sample standard deviation of numeric input values"

)

DESCR

(

"sample standard deviation of float8 input values"

)

DESCR

(

"sample standard deviation of float4 input values"

)

DESCR

(

"sample standard deviation of smallint input values"

)

DESCR

(

"sample standard deviation of integer input values"

)

DESCR

(

"sample standard deviation of bigint input values"

)

DESCR

(

"population standard deviation of numeric input values"

)

DESCR

(

"population standard deviation of float8 input values"

)

DESCR

(

"population standard deviation of float4 input values"

)

DESCR

(

"population standard deviation of smallint input values"

)

DESCR

(

"population standard deviation of integer input values"

)

DESCR

(

"population standard deviation of bigint input values"

)

DESCR

(

"historical alias for var_samp"

)

DESCR

(

"sample variance of numeric input values (square of the sample standard deviation)"

)

DESCR

(

"sample variance of float8 input values (square of the sample standard deviation)"

)

DESCR

(

"sample variance of float4 input values (square of the sample standard deviation)"

)

DESCR

(

"sample variance of smallint input values (square of the sample standard deviation)"

)

DESCR

(

"sample variance of integer input values (square of the sample standard deviation)"

)

DESCR

(

"sample variance of bigint input values (square of the sample standard deviation)"

)

DESCR

(

"population variance of numeric input values (square of the population standard deviation)"

)

DESCR

(

"population variance of float8 input values (square of the population standard deviation)"

)

DESCR

(

"population variance of float4 input values (square of the population standard deviation)"

)

DESCR

(

"population variance of smallint input values (square of the population standard deviation)"

)

DESCR

(

"population variance of integer input values (square of the population standard deviation)"

)

DESCR

(

"population variance of bigint input values (square of the population standard deviation)"

)

DESCR

(

"number of input rows"

)

DESCR

(

"number of input rows for which the input expression is not null"

)

DESCR

(

"minimum value of all tid input values"

)

DESCR

(

"minimum value of all bpchar input values"

)

DESCR

(

"minimum value of all anyarray input values"

)

DESCR

(

"minimum value of all numeric input values"

)

DESCR

(

"minimum value of all text values"

)

DESCR

(

"minimum value of all interval input values"

)

DESCR

(

"minimum value of all timestamp with time zone input values"

)

DESCR

(

"minimum value of all timestamp input values"

)

DESCR

(

"minimum value of all money input values"

)

DESCR

(

"minimum value of all time with time zone input values"

)

DESCR

(

"minimum value of all time input values"

)

DESCR

(

"minimum value of all date input values"

)

DESCR

(

"minimum value of all abstime input values"

)

DESCR

(

"minimum value of all float8 input values"

)

DESCR

(

"minimum value of all float4 input values"

)

DESCR

(

"minimum value of all oid input values"

)

DESCR

(

"minimum value of all smallint input values"

)

DESCR

(

"minimum value of all integer input values"

)

DESCR

(

"minimum value of all bigint input values"

)

DESCR

(

"maximum value of all tid input values"

)

DESCR

(

"maximum value of all bpchar input values"

)

DESCR

(

"maximum value of all anyarray input values"

)

DESCR

(

"maximum value of all numeric input values"

)

DESCR

(

"maximum value of all text input values"

)

DESCR

(

"maximum value of all interval input values"

)

DESCR

(

"maximum value of all timestamp with time zone input values"

)

DESCR

(

"maximum value of all timestamp input values"

)

DESCR

(

"maximum value of all money input values"

)

DESCR

(

"maximum value of all time with time zone input values"

)

DESCR

(

"maximum value of all time input values"

)

DESCR

(

"maximum value of all date input values"

)

DESCR

(

"maximum value of all abstime input values"

)

DESCR

(

"maximum value of all float8 input values"

)

DESCR

(

"maximum value of all float4 input values"

)

DESCR

(

"maximum value of all oid input values"

)

DESCR

(

"maximum value of all smallint input values"

)

DESCR

(

"maximum value of all integer input values"

)

DESCR

(

"maximum value of all bigint input values"

)

DESCR

(

"sum as numeric across all numeric input values"

)

DESCR

(

"sum as interval across all interval input values"

)

DESCR

(

"sum as money across all money input values"

)

DESCR

(

"sum as float8 across all float8 input values"

)

DESCR

(

"sum as float4 across all float4 input values"

)

DESCR

(

"sum as bigint across all smallint input values"

)

DESCR

(

"sum as bigint across all integer input values"

)

DESCR

(

"sum as numeric across all bigint input values"

)

DESCR

(

"the average (arithmetic mean) as interval of all interval values"

)

DESCR

(

"the average (arithmetic mean) as float8 of all float8 values"

)

DESCR

(

"the average (arithmetic mean) as float8 of all float4 values"

)

DESCR

(

"the average (arithmetic mean) as numeric of all numeric values"

)

DESCR

(

"the average (arithmetic mean) as numeric of all smallint values"

)

DESCR

(

"the average (arithmetic mean) as numeric of all integer values"

)

DESCR

(

"the average (arithmetic mean) as numeric of all bigint values"

)

DESCR

(

"convert boolean to text"

)

DESCR

(

"sleep for the specified time in seconds"

)

DESCR

(

"list all files in a directory"

)

DESCR

(

"read text from a file"

)

DESCR

(

"get information about file"

)

DESCR

(

"rotate log file"

)

DESCR

(

"reload configuration files"

)

DESCR

(

"true if xlog replay is paused"

)

DESCR	(	"resume xlog	replay,
		if it was paused"
	)

DESCR

(

"pause xlog replay"

)

DESCR

(

"timestamp of last replay xact"

)

DESCR

(

"last xlog replay location"

)

DESCR

(

"current xlog flush location"

)

DESCR

(

"true if server is in recovery"

)

DESCR

(

"export a snapshot"

)

DESCR	(	"difference in	bytes,
		given two xlog locations"
	)

DESCR	(	"xlog	filename,
		given an xlog location"
	)

DESCR	(	"xlog filename and byte	offset,
		given an xlog location"
	)

DESCR

(

"current xlog insert location"

)

DESCR

(

"current xlog write location"

)

DESCR

(

"create a named restore point"

)

DESCR

(

"switch to new xlog file"

)

DESCR

(

"start time of an online backup"

)

DESCR

(

"true if server is in online backup"

)

DESCR

(

"finish taking an online backup"

)

DESCR

(

"prepare for taking an online backup"

)

DESCR

(

"terminate a server process"

)

DESCR

(

"cancel a server process' current query"

)

DESCR

(

"is schema another session's temp schema?"

)

DESCR	(	"get OID of current session's temp	schema,
		if any"
	)

DESCR

(

"is collation visible in search path?"

)

DESCR

(

"is text search configuration visible in search path?"

)

DESCR

(

"is text search template visible in search path?"

)

DESCR

(

"is text search dictionary visible in search path?"

)

DESCR

(

"is text search parser visible in search path?"

)

DESCR

(

"is conversion visible in search path?"

)

DESCR

(

"is opfamily visible in search path?"

)

DESCR

(

"is opclass visible in search path?"

)

DESCR

(

"is operator visible in search path?"

)

DESCR

(

"is function visible in search path?"

)

DESCR

(

"is type visible in search path?"

)

DESCR

(

"is table visible in search path?"

)

DESCR

(

"get machine-parseable identification of SQL object"

)

DESCR

(

"get identification of SQL object"

)

DESCR

(

"view members of a multixactid"

)

DESCR

(

"view two-phase transactions"

)

DESCR

(

"view system lock information"

)

DESCR

(

"SHOW ALL as a function"

)

DESCR

(

"SET X as a function"

)

DESCR

(

"SHOW X as a function"

)

DESCR

(

"convert bitstring to int8"

)

DESCR

(

"convert int8 to bitstring"

)

DESCR

(

"extract text matching SQL99 regular expression"

)

DESCR

(

"extract text matching regular expression"

)

DESCR

(

"format timestamp to text"

)

DESCR

(

"convert time to time with time zone"

)

DESCR

(

"convert time with time zone to time"

)

DESCR

(

"adjust time with time zone to new zone"

)

DESCR

(

"convert timestamp to abstime"

)

DESCR

(

"convert timestamp to date"

)

DESCR

(

"convert timestamp to timestamp with time zone"

)

DESCR

(

"convert timestamp with time zone to timestamp"

)

DESCR

(

"convert date and time to timestamp"

)

DESCR

(

"convert date to timestamp"

)

DESCR

(

"convert abstime to timestamp"

)

DESCR

(

"extract field from timestamp"

)

DESCR

(

"truncate timestamp to specified units"

)

DESCR

(

"convert timestamp with time zone to time"

)

DESCR

(

"trim both ends of string"

)

DESCR

(

"adjust time with time zone precision"

)

DESCR

(

"adjust time precision"

)

DESCR

(

"adjust timestamptz precision"

)

DESCR

(

"adjust timestamp precision"

)

DESCR

(

"transform a time length coercion"

)

DESCR

(

"transform a timestamp length coercion"

)

DESCR

(

"convert ascii-encoded text string into bytea value"

)

DESCR

(

"convert bytea value into some ascii-only text string"

)

DESCR

(

"tablespace location"

)

DESCR

(

"current trigger depth"

)

DESCR

(

"statistics: reset collected statistics for a single function in the current database"

)

DESCR

(

"statistics: reset collected statistics for a single table or index in the current database"

)

DESCR

(

"statistics: reset collected statistics shared across the cluster"

)

DESCR

(

"statistics: reset collected statistics for current database"

)

DESCR

(

"statistics: discard current transaction's statistics snapshot"

)

DESCR	(	"statistics: self execution time of function in current	transaction,
		in msec"
	)

DESCR	(	"statistics: total execution time of function in current	transaction,
		in msec"
	)

DESCR

(

"statistics: number of function calls in current transaction"

)

DESCR

(

"statistics: number of blocks found in cache in current transaction"

)

DESCR

(

"statistics: number of blocks fetched in current transaction"

)

DESCR

(

"statistics: number of tuples hot updated in current transaction"

)

DESCR

(

"statistics: number of tuples deleted in current transaction"

)

DESCR

(

"statistics: number of tuples updated in current transaction"

)

DESCR

(

"statistics: number of tuples inserted in current transaction"

)

DESCR

(

"statistics: number of tuples fetched by idxscan in current transaction"

)

DESCR

(

"statistics: number of tuples read by seqscan in current transaction"

)

DESCR

(

"statistics: number of scans done for table/index in current transaction"

)

DESCR	(	"statistics: self execution time of	function,
		in msec"
	)

DESCR	(	"statistics: total execution time of	function,
		in msec"
	)

DESCR

(

"statistics: number of function calls"

)

DESCR

(

"statistics: number of buffer allocations"

)

DESCR

(

"statistics: number of backend buffer writes that did their own fsync"

)

DESCR

(

"statistics: number of buffers written by backends"

)

DESCR	(	"statistics: checkpoint time spent synchronizing buffers to	disk,
		in msec"
	)

DESCR	(	"statistics: checkpoint time spent writing buffers to	disk,
		in msec"
	)

DESCR

(

"statistics: last reset for the bgwriter"

)

DESCR

(

"statistics: number of times the bgwriter stopped processing when it had written too many buffers while cleaning"

)

DESCR

(

"statistics: number of buffers written by the bgwriter for cleaning dirty buffers"

)

DESCR

(

"statistics: number of buffers written by the bgwriter during checkpoints"

)

DESCR

(

"statistics: number of backend requested checkpoints started by the bgwriter"

)

DESCR

(

"statistics: number of timed checkpoints started by the bgwriter"

)

DESCR	(	"statistics: block write	time,
		in msec"
	)

DESCR	(	"statistics: block read	time,
		in msec"
	)

DESCR

(

"statistics: number of bytes in temporary files written"

)

DESCR

(

"statistics: number of temporary files written"

)

DESCR

(

"statistics: last reset for a database"

)

DESCR

(

"statistics: deadlocks detected in database"

)

DESCR

(

"statistics: recovery conflicts in database"

)

DESCR

(

"statistics: recovery conflicts in database caused by buffer deadlock"

)

DESCR

(

"statistics: recovery conflicts in database caused by shared buffer pin"

)

DESCR

(

"statistics: recovery conflicts in database caused by snapshot expiry"

)

DESCR

(

"statistics: recovery conflicts in database caused by relation lock"

)

DESCR

(

"statistics: recovery conflicts in database caused by drop tablespace"

)

DESCR

(

"statistics: tuples deleted in database"

)

DESCR

(

"statistics: tuples updated in database"

)

DESCR

(

"statistics: tuples inserted in database"

)

DESCR

(

"statistics: tuples fetched for database"

)

DESCR

(

"statistics: tuples returned for database"

)

DESCR

(

"statistics: blocks found in cache for database"

)

DESCR

(

"statistics: blocks fetched for database"

)

DESCR

(

"statistics: transactions rolled back"

)

DESCR

(

"statistics: transactions committed"

)

DESCR

(

"statistics: number of backends in database"

)

DESCR

(

"statistics: port number of client connected to backend"

)

DESCR

(

"statistics: address of client connected to backend"

)

DESCR

(

"statistics: start time for current backend session"

)

DESCR

(

"statistics: start time for backend's current transaction"

)

DESCR

(

"statistics: start time for current query of backend"

)

DESCR

(

"statistics: is backend currently waiting for a lock"

)

DESCR

(

"statistics: current query of backend"

)

DESCR

(

"statistics: user ID of backend"

)

DESCR

(

"statistics: database ID of backend"

)

DESCR

(

"statistics: PID of backend"

)

DESCR

(

"statistics: current backend PID"

)

DESCR

(

"statistics: information about currently active replication"

)

DESCR

(

"statistics: information about currently active backends"

)

DESCR

(

"statistics: currently active backend IDs"

)

DESCR

(

"statistics: number of auto analyzes for a table"

)

DESCR

(

"statistics: number of manual analyzes for a table"

)

DESCR

(

"statistics: number of auto vacuums for a table"

)

DESCR

(

"statistics: number of manual vacuums for a table"

)

DESCR

(

"statistics: last auto analyze time for a table"

)

DESCR

(

"statistics: last manual analyze time for a table"

)

DESCR

(

"statistics: last auto vacuum time for a table"

)

DESCR

(

"statistics: last manual vacuum time for a table"

)

DESCR

(

"statistics: number of blocks found in cache"

)

DESCR

(

"statistics: number of blocks fetched"

)

DESCR

(

"statistics: number of dead tuples"

)

DESCR

(

"statistics: number of live tuples"

)

DESCR

(

"statistics: number of tuples hot updated"

)

DESCR

(

"statistics: number of tuples deleted"

)

DESCR

(

"statistics: number of tuples updated"

)

DESCR

(

"statistics: number of tuples inserted"

)

DESCR

(

"statistics: number of tuples fetched by idxscan"

)

DESCR

(

"statistics: number of tuples read by seqscan"

)

DESCR

(

"statistics: number of scans done for table/index"

)

DESCR

(

"current user privilege on any column by rel oid"

)

DESCR

(

"current user privilege on any column by rel name"

)

DESCR	(	"user privilege on any column by user	oid,
		rel oid"
	)

DESCR	(	"user privilege on any column by user	oid,
		rel name"
	)

DESCR	(	"user privilege on any column by	username,
		rel oid"
	)

DESCR	(	"user privilege on any column by	username,
		rel name"
	)

DESCR	(	"current user privilege on column by rel	name,
		col attnum"
	)

DESCR	(	"current user privilege on column by rel	name,
		col name"
	)

DESCR	(	"user privilege on column by user	oid,
		rel	name,
		col attnum"
	)

DESCR	(	"user privilege on column by user	oid,
		rel	name,
		col name"
	)

DESCR	(	"user privilege on column by	username,
		rel	name,
		col attnum"
	)

DESCR	(	"user privilege on column by	username,
		rel	name,
		col name"
	)

DESCR

(

"current user privilege on sequence by seq oid"

)

DESCR

(

"current user privilege on sequence by seq name"

)

DESCR	(	"user privilege on sequence by user	oid,
		seq oid"
	)

DESCR	(	"user privilege on sequence by user	oid,
		seq name"
	)

DESCR	(	"user privilege on sequence by	username,
		seq oid"
	)

DESCR	(	"user privilege on sequence by	username,
		seq name"
	)

DESCR

(

"current user privilege on relation by rel oid"

)

DESCR

(

"current user privilege on relation by rel name"

)

DESCR	(	"user privilege on relation by user	oid,
		rel oid"
	)

DESCR	(	"user privilege on relation by user	oid,
		rel name"
	)

DESCR	(	"user privilege on relation by	username,
		rel oid"
	)

DESCR	(	"user privilege on relation by	username,
		rel name"
	)

DESCR

(

"encode text from encoding to ASCII text"

)

DESCR

(

"encode text from DB encoding to ASCII text"

)

DESCR

(

"concatenate aggregate input into a bytea"

)

DESCR

(

"concatenate aggregate input into a string"

)

DESCR

(

"join selectivity of case-insensitive regex non-match"

)

DESCR

(

"join selectivity of NOT LIKE"

)

DESCR

(

"join selectivity of regex non-match"

)

DESCR

(

"join selectivity of case-insensitive regex match"

)

DESCR

(

"join selectivity of LIKE"

)

DESCR

(

"join selectivity of regex match"

)

DESCR

(

"restriction selectivity of case-insensitive regex non-match"

)

DESCR

(

"restriction selectivity of NOT LIKE"

)

DESCR

(

"restriction selectivity of regex non-match"

)

DESCR

(

"restriction selectivity of case-insensitive regex match"

)

DESCR

(

"restriction selectivity of LIKE"

)

DESCR

(

"restriction selectivity of regex match"

)

DESCR

(

"join selectivity of NOT ILIKE"

)

DESCR

(

"join selectivity of ILIKE"

)

DESCR

(

"restriction selectivity of NOT ILIKE"

)

DESCR

(

"restriction selectivity of ILIKE"

)

DESCR

(

"length in bits"

)

DESCR

(

"format text message"

)

DESCR

(

"reverse text"

)

DESCR

(

"extract the last n characters"

)

DESCR

(

"extract the first n characters"

)

DESCR

(

"concatenate values with separators"

)

DESCR

(

"concatenate values"

)

DESCR

(

"quote a possibly-null data value for usage in a querystring"

)

DESCR

(

"quote a possibly-null literal for usage in a querystring"

)

DESCR

(

"quote a data value for usage in a querystring"

)

DESCR

(

"quote a literal for usage in a querystring"

)

DESCR

(

"quote an identifier for usage in a querystring"

)

DESCR

(

"format interval to text"

)

DESCR

(

"convert text to date"

)

DESCR

(

"convert text to timestamp with time zone"

)

DESCR

(

"convert text to numeric"

)

DESCR

(

"format float8 to text"

)

DESCR

(

"format float4 to text"

)

DESCR

(

"format int8 to text"

)

DESCR

(

"format int4 to text"

)

DESCR

(

"format numeric to text"

)

DESCR

(

"format timestamp with time zone to text"

)

DESCR

(

"convert numeric to int2"

)

DESCR

(

"convert int2 to numeric"

)

DESCR

(

"convert int8 to numeric"

)

DESCR

(

"convert numeric to int8"

)

DESCR

(

"increment by one"

)

DESCR

(

"trunc(x/y)"

)

DESCR

(

"convert numeric to float8"

)

DESCR

(

"convert numeric to float4"

)

DESCR

(

"convert numeric to int4"

)

DESCR

(

"convert float8 to numeric"

)

DESCR

(

"convert float4 to numeric"

)

DESCR

(

"convert int4 to numeric"

)

DESCR

(

"logarithm base m of n"

)

DESCR

(

"value truncated to 'scale' of zero"

)

DESCR

(

"value truncated to 'scale'"

)

DESCR

(

"value rounded to 'scale' of zero"

)

DESCR

(

"value rounded to 'scale'"

)

DESCR

(

"adjust numeric to typmod precision/scale"

)

DESCR

(

"transform a numeric length coercion"

)

DESCR

(

"server's port number for this connection"

)

DESCR

(

"inet address of the server"

)

DESCR

(

"client's port number for this connection"

)

DESCR

(

"inet address of the client"

)

DESCR

(

"convert inet to cidr"

)

DESCR

(

"hostmask of address"

)

DESCR

(

"show all parts of inet/cidr value"

)

DESCR

(

"show address octets only"

)

DESCR

(

"broadcast address of network"

)

DESCR

(

"netmask length"

)

DESCR

(

"netmask of address"

)

DESCR

(

"network part of address"

)

DESCR

(

"address family (4 for IPv4, 6 for IPv6)"

)

DESCR

(

"change netmask of cidr"

)

DESCR

(

"change netmask of inet"

)

DESCR

(

"abbreviated display of cidr value"

)

DESCR

(

"abbreviated display of inet value"

)

DESCR

(

"MAC manufacturer fields"

)

DESCR

(

"substitute portion of bitstring"

)

DESCR

(

"position of sub-bitstring"

)

DESCR

(

"adjust varbit() to typmod length"

)

DESCR

(

"transform a varbit length coercion"

)

DESCR

(

"adjust bit() to typmod length"

)

DESCR

(

"convert bitstring to int4"

)

DESCR

(

"convert int4 to bitstring"

)

DESCR

(

"bitstring length"

)

DESCR

(

"extract portion of bitstring"

)

DESCR

(

"referential integrity ON UPDATE NO ACTION"

)

DESCR

(

"referential integrity ON DELETE NO ACTION"

)

DESCR

(

"referential integrity ON UPDATE SET DEFAULT"

)

DESCR

(

"referential integrity ON DELETE SET DEFAULT"

)

DESCR

(

"referential integrity ON UPDATE SET NULL"

)

DESCR

(

"referential integrity ON DELETE SET NULL"

)

DESCR

(

"referential integrity ON UPDATE RESTRICT"

)

DESCR

(

"referential integrity ON DELETE RESTRICT"

)

DESCR

(

"referential integrity ON UPDATE CASCADE"

)

DESCR

(

"referential integrity ON DELETE CASCADE"

)

DESCR

(

"referential integrity FOREIGN KEY ... REFERENCES"

)

DESCR

(

"deferred UNIQUE constraint check"

)

DESCR

(

"is a relation scannable"

)

DESCR

(

"is a view updatable"

)

DESCR

(

"is a view insertable-into"

)

DESCR

(

"collation of the argument; implementation of the COLLATION FOR expression"

)

DESCR

(

"type of the argument"

)

DESCR

(

"convert generic options array to name/value table"

)

DESCR

(

"list of SQL keywords"

)

DESCR

(

"result type of a function"

)

DESCR

(

"identity argument list of a function"

)

DESCR

(

"argument list of a function"

)

DESCR

(

"definition of a function"

)

DESCR

(

"name of sequence for a serial column"

)

DESCR

(

"deparse an encoded expression"

)

DESCR

(

"constraint description"

)

DESCR

(

"trigger description"

)

DESCR

(

"index description"

)

DESCR

(

"role name by OID (with fallback)"

)

DESCR

(

"select statement of a view"

)

DESCR

(

"source text of a rule"

)

DESCR

(

"maximum octet length of a character in given encoding"

)

DESCR

(

"convert encoding id to encoding name"

)

DESCR

(

"convert encoding name to encoding id"

)

DESCR

(

"convert string with specified encoding names"

)

DESCR

(

"convert string with specified destination encoding name"

)

DESCR

(

"convert string with specified source encoding name"

)

DESCR

(

"length of string in specified encoding"

)

DESCR

(

"encoding name of current database"

)

DESCR

(

"convert int8 number to hex"

)

DESCR

(

"convert int4 number to hex"

)

DESCR

(

"split string by pattern"

)

DESCR

(

"split string by field_sep and return field_num"

)

DESCR

(

"find all match groups for regexp"

)

DESCR

(

"replace text using regexp"

)

DESCR

(

"replace all occurrences in string of old_substr with new_substr"

)

DESCR

(

"trim spaces from both ends of string"

)

DESCR

(

"trim selected characters from both ends of string"

)

DESCR

(

"trim spaces from right end of string"

)

DESCR

(

"trim spaces from left end of string"

)

DESCR

(

"map a set of characters appearing in string"

)

DESCR

(

"extract portion of string"

)

DESCR

(

"trim selected characters from right end of string"

)

DESCR

(

"trim selected characters from left end of string"

)

DESCR

(

"right-pad string to length"

)

DESCR

(

"left-pad string to length"

)

DESCR

(

"capitalize each word"

)

DESCR

(

"uppercase"

)

DESCR

(

"lowercase"

)

DESCR

(

"convert LIKE pattern to use backslash escapes"

)

DESCR

(

"convert SQL99 regexp pattern to POSIX style"

)

DESCR

(

"replicate string n times"

)

DESCR

(

"convert first char to int4"

)

DESCR

(

"PI"

)

DESCR

(

"degrees to radians"

)

DESCR

(

"radians to degrees"

)

DESCR

(

"cotangent"

)

DESCR

(

"tangent"

)

DESCR

(

"cosine"

)

DESCR

(

"sine"

)

DESCR	(	"	arctangent,
		two arguments"
	)

DESCR

(

"arctangent"

)

DESCR

(

"arccosine"

)

DESCR

(

"arcsine"

)

DESCR

(

"set random seed"

)

DESCR

(

"random value"

)

DESCR	(	"sequence	parameters,
		for use by information schema"
	)

DESCR

(

"set sequence value and is_called status"

)

DESCR

(

"set sequence value"

)

DESCR

(

"sequence current value"

)

DESCR

(

"sequence next value"

)

DESCR

(

"does not match LIKE expression"

)

DESCR

(

"matches LIKE expression"

)

DESCR

(

"number of points"

)

DESCR

(

"convert circle to 12-vertex polygon"

)

DESCR

(

"diagonal of"

)

DESCR

(

"sum of path segments"

)

DESCR

(

"distance between endpoints"

)

DESCR

(

"construct line from points"

)

DESCR

(

"convert to tinterval"

)

DESCR

(

"convert circle to box"

)

DESCR

(

"convert box to circle"

)

DESCR

(

"convert vertex count and circle to polygon"

)

DESCR

(

"convert polygon to circle"

)

DESCR

(

"convert point and radius to circle"

)

DESCR

(

"radius of circle"

)

DESCR

(

"diameter of circle"

)

DESCR

(

"area of circle"

)

DESCR

(

"convert path to polygon"

)

DESCR

(

"convert box to polygon"

)

DESCR

(

"convert polygon to path"

)

DESCR

(

"convert polygon to bounding box"

)

DESCR	(	"convert	x,
		y to point"
	)

DESCR

(

"open path"

)

DESCR

(

"close path"

)

DESCR

(

"path open?"

)

DESCR

(

"path closed?"

)

DESCR

(

"convert points to box"

)

DESCR

(

"convert interval to time"

)

DESCR

(

"center of"

)

DESCR

(

"horizontal"

)

DESCR

(

"vertical"

)

DESCR

(

"perpendicular"

)

DESCR

(

"parallel"

)

DESCR

(

"horizontally aligned"

)

DESCR

(

"vertically aligned"

)

DESCR

(

"current schema search list"

)

DESCR

(

"current schema name"

)

DESCR

(

"convert name to varchar"

)

DESCR

(

"convert varchar to name"

)

DESCR

(

"absolute value"

)

DESCR

(

"factorial"

)

DESCR

(

"finite interval?"

)

DESCR

(

"finite timestamp?"

)

DESCR

(

"finite date?"

)

DESCR

(

"convert timestamp with time zone to time with time zone"

)

DESCR

(

"date difference from today preserving months and years"

)

DESCR

(

"extract field from time"

)

DESCR

(

"extract field from date"

)

DESCR

(

"extract field from reltime"

)

DESCR

(

"extract field from abstime"

)

DESCR

(

"convert time to interval"

)

DESCR

(

"convert abstime to time"

)

DESCR

(

"convert date and time with time zone to timestamp with time zone"

)

DESCR

(

"print type names of oidvector field"

)

DESCR	(	"	deprecated,
		use two-argument form instead"
	)

DESCR

(

"exponentiation"

)

DESCR

(

"cube root"

)

DESCR

(

"square root"

)

DESCR

(

"base 10 logarithm"

)

DESCR

(

"character length"

)

DESCR

(

"convert timestamp to time"

)

DESCR

(

"join selectivity for containment comparison operators"

)

DESCR

(

"restriction selectivity for containment comparison operators"

)

DESCR

(

"join selectivity for position-comparison operators"

)

DESCR

(

"restriction selectivity for position-comparison operators"

)

DESCR

(

"current clock time"

)

DESCR

(

"current statement time"

)

DESCR

(

"current transaction time"

)

DESCR

(

"latest tid of a tuple"

)

DESCR

(

"trigger to suppress updates when new and old records match"

)

DESCR

(

"convert oid to int8"

)

DESCR

(

"convert int8 to oid"

)

DESCR

(

"extract field from time with time zone"

)

DESCR

(

"intervals overlap?"

)

DESCR	(	"	increment,
		ignores second argument"
	)

DESCR

(

"truncate interval to specified units"

)

DESCR

(

"truncate timestamp with time zone to specified units"

)

DESCR

(

"get description for object id and shared catalog name"

)

DESCR

(

"get description for table column"

)

DESCR

(

"get description for object id and catalog name"

)

DESCR

(

"adjust interval precision"

)

DESCR

(

"transform an interval length coercion"

)

DESCR

(

"date difference preserving months and years"

)

DESCR

(

"convert interval to reltime"

)

DESCR	(	"age of a transaction	ID,
		in transactions before current transaction"
	)

DESCR

(

"convert timestamp with time zone to abstime"

)

DESCR

(

"convert abstime to date"

)

DESCR

(

"convert timestamp with time zone to date"

)

DESCR

(

"convert reltime to interval"

)

DESCR

(

"convert date and time to timestamp with time zone"

)

DESCR

(

"promote groups of 30 days to numbers of months"

)

DESCR

(

"promote groups of 24 hours to numbers of days"

)

DESCR

(

"promote groups of 24 hours to numbers of days and promote groups of 30 days to numbers of months"

)

DESCR

(

"convert date to timestamp with time zone"

)

DESCR

(

"convert abstime to timestamp with time zone"

)

DESCR

(

"extract field from interval"

)

DESCR

(

"extract field from timestamp with time zone"

)

DESCR

(

"convert UNIX epoch to timestamptz"

)

DESCR

(

"format a type oid and atttypmod to canonical SQL"

)

DESCR

(

"I/O typmod"

)

DESCR	(	"convert ACL item array to	table,
		for use by information schema"
	)

DESCR

(

"TODO"

)

DESCR

(

"make ACL item"

)

DESCR

(

"contains"

)

DESCR

(

"remove ACL item"

)

DESCR

(

"add/update ACL item"

)

DESCR

(

"adjust timestamp to new time zone"

)

DESCR

(

"convert points to line segment"

)

DESCR

(

"slope between points"

)

DESCR

(

"box diagonal"

)

DESCR

(

"area of a closed path"

)

DESCR

(

"box height"

)

DESCR

(

"box width"

)

DESCR

(

"box area"

)

DESCR

(

"large object unlink (delete)"

)

DESCR

(

"truncate large object (64 bit)"

)

DESCR

(

"truncate large object"

)

DESCR

(

"large object position (64 bit)"

)

DESCR

(

"large object position"

)

DESCR

(

"large object create"

)

DESCR

(

"large object seek (64 bit)"

)

DESCR

(

"large object seek"

)

DESCR

(

"large object write"

)

DESCR

(

"large object read"

)

DESCR

(

"large object close"

)

DESCR

(

"large object open"

)

DESCR

(

"convert char to text"

)

DESCR

(

"convert text to char"

)

DESCR

(

"modulus"

)

DESCR

(

"convert int8 to money"

)

DESCR

(

"convert int4 to money"

)

DESCR

(

"convert numeric to money"

)

DESCR

(

"convert money to numeric"

)

DESCR

(

"output money amount as words"

)

DESCR

(

"get the currently executing query"

)

DESCR

(

"name of the current database"

)

DESCR

(

"convert char to char(n)"

)

DESCR

(

"position of substring"

)

DESCR

(

"gist(internal)"

)

DESCR

(

"increment"

)

DESCR

(

"large object export"

)

DESCR

(

"large object import"

)

DESCR

(

"storage manager"

)

DESCR

(

"join selectivity for array-containment operators"

)

DESCR

(

"restriction selectivity for array-containment operators"

)

DESCR

(

"array typanalyze"

)

DESCR

(

"concatenate aggregate input into an array"

)

DESCR

(

"aggregate final function"

)

DESCR

(

"replace any occurrences of an element in an array"

)

DESCR

(

"remove any occurrences of an element from an array"

)

DESCR

(

"expand array to set of rows"

)

DESCR

(

"array constructor with value"

)

DESCR

(

"array subscripts generator"

)

DESCR	(	"concatenate array	elements,
		using delimiter and null	string,
		into text"
	)

DESCR	(	"split delimited text into	text[],
		with null string"
	)

DESCR	(	"concatenate array	elements,
		using	delimiter,
		into text"
	)

DESCR

(

"split delimited text into text"

[]

)

DESCR

(

"prepend element onto front of array"

)

DESCR

(

"append element onto end of array"

)

DESCR

(

"array length"

)

DESCR

(

"array upper dimension"

)

DESCR

(

"array lower dimension"

)

DESCR

(

"number of array dimensions"

)

DESCR

(

"array dimensions"

)

DESCR

(

"session user name"

)

DESCR

(

"current user name"

)

DESCR

(

"substitute portion of string"

)

DESCR

(

"set bit"

)

DESCR

(

"get bit"

)

DESCR

(

"set byte"

)

DESCR

(

"get byte"

)

DESCR

(

"octet length"

)

DESCR	(	"	deprecated,
		use current_user instead"
	)

DESCR

(

"adjust varchar() to typmod length"

)

DESCR

(

"transform a varchar length coercion"

)

DESCR

(

"adjust char() to typmod length"

)

DESCR

(

"convert int2 to int8"

)

DESCR

(

"convert int8 to int2"

)

DESCR

(

"convert float4 to int8"

)

DESCR

(

"convert int8 to float4"

)

DESCR

(

"convert float8 to int8"

)

DESCR

(

"convert int8 to float8"

)

DESCR

(

"convert int4 to int8"

)

DESCR

(

"convert int8 to int4"

)

DESCR

(

"hash"

)

DESCR

(

"hash(internal)"

)

DESCR

(

"convert char(n) to name"

)

DESCR

(

"convert name to char(n)"

)

DESCR

(

"convert text to name"

)

DESCR

(

"convert name to text"

)

DESCR

(

"convert char(n) to text"

)

DESCR

(

"sort support"

)

DESCR

(

"less-equal-greater"

)

DESCR

(

"btree(internal)"

)

DESCR

(

"convert float4 to int4"

)

DESCR

(

"convert int4 to float4"

)

DESCR

(

"convert float8 to int4"

)

DESCR

(

"convert int4 to float8"

)

DESCR

(

"convert int4 to int2"

)

DESCR

(

"convert int2 to int4"

)

DESCR

(

"convert float8 to float4"

)

DESCR

(

"convert float4 to float8"

)

DESCR

(

"bucket number of operand in equidepth histogram"

)

DESCR

(

"finite abstime?"

)

DESCR

(

"current date and time - increments during transactions"

)

DESCR

(

"end of interval"

)

DESCR

(

"current date and time (abstime)"

)

DESCR

(

"tinterval to reltime"

)

DESCR

(

"convert float4 to int2"

)

DESCR

(

"convert float8 to int2"

)

DESCR

(

"convert int2 to float4"

)

DESCR

(

"convert int2 to float8"

)

DESCR

(

"natural logarithm"

)

DESCR

(

"natural exponential (e^x)"

)

DESCR

(

"sign of value"

)

DESCR

(

"largest integer <= value"

)

DESCR

(

"smallest integer >= value"

)

DESCR

(

"truncate to integer"

)

DESCR

(

"round to nearest integer"

)

DESCR

(

"smaller of two"

)

DESCR

(

"larger of two"

)

DESCR

(

"aggregate transition function"

)

DESCR

(

"join selectivity for area-comparison operators"

)

DESCR

(

"restriction selectivity for area-comparison operators"

)

DESCR	(	"join selectivity	of,
		and related operators on scalar datatypes"
	)

DESCR

(

"join selectivity of <> and related operators"

)

DESCR	(	"restriction selectivity	of,
		and related operators on scalar datatypes"
	)

DESCR

(

"restriction selectivity of <> and related operators"

)

DESCR

(

)

DESCR

(

"PostgreSQL version string"

)

DESCR

(

"length"

)

DESCR

(

"convert int4 to char"

)

DESCR

(

"convert char to int4"

)

DESCR

(

"I/O"

)

DESCR

(

"list objects dropped by the current command"

)

---

Variable Documentation

FormData_pg_proc

Definition at line 74 of file pg_proc.h.