diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-05-30 23:09:07 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-05-30 23:09:07 +0000 |
| commit | 978129f28e0cba0b6364df672fbd1ae88e3397c4 (patch) | |
| tree | 94dcfb1cb3494d7981dc9d09c10047129577db40 /contrib/tablefunc/tablefunc.sql.in | |
| parent | b215fae891a7b0e9bcd7126f3aab1c477d4947b1 (diff) | |
| download | postgresql-978129f28e0cba0b6364df672fbd1ae88e3397c4.tar.gz | |
Document get_call_result_type() and friends; mark TypeGetTupleDesc()
and RelationNameGetTupleDesc() as deprecated; remove uses of the
latter in the contrib library. Along the way, clean up crosstab()
code and documentation a little.
Diffstat (limited to 'contrib/tablefunc/tablefunc.sql.in')
| -rw-r--r-- | contrib/tablefunc/tablefunc.sql.in | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/contrib/tablefunc/tablefunc.sql.in b/contrib/tablefunc/tablefunc.sql.in index f3d5d3d8a1..fee9cb7e17 100644 --- a/contrib/tablefunc/tablefunc.sql.in +++ b/contrib/tablefunc/tablefunc.sql.in @@ -6,6 +6,13 @@ RETURNS setof float8 AS 'MODULE_PATHNAME','normal_rand' LANGUAGE 'C' VOLATILE STRICT; +-- the generic crosstab function: +CREATE OR REPLACE FUNCTION crosstab(text) +RETURNS setof record +AS 'MODULE_PATHNAME','crosstab' +LANGUAGE 'C' STABLE STRICT; + +-- examples of building custom type-specific crosstab functions: CREATE TYPE tablefunc_crosstab_2 AS ( row_name TEXT, @@ -45,6 +52,7 @@ RETURNS setof tablefunc_crosstab_4 AS 'MODULE_PATHNAME','crosstab' LANGUAGE 'C' STABLE STRICT; +-- obsolete: CREATE OR REPLACE FUNCTION crosstab(text,int) RETURNS setof record AS 'MODULE_PATHNAME','crosstab' |