codekingpro/portable-devtools

1/* contrib/tablefunc/tablefunc--1.0.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION tablefunc" to load this file. \quit5 6CREATE FUNCTION normal_rand(int4, float8, float8)7RETURNS setof float88AS 'MODULE_PATHNAME','normal_rand'9LANGUAGE C VOLATILE STRICT;10 11-- the generic crosstab function:12CREATE FUNCTION crosstab(text)13RETURNS setof record14AS 'MODULE_PATHNAME','crosstab'15LANGUAGE C STABLE STRICT;16 17-- examples of building custom type-specific crosstab functions:18CREATE TYPE tablefunc_crosstab_2 AS19(20	row_name TEXT,21	category_1 TEXT,22	category_2 TEXT23);24 25CREATE TYPE tablefunc_crosstab_3 AS26(27	row_name TEXT,28	category_1 TEXT,29	category_2 TEXT,30	category_3 TEXT31);32 33CREATE TYPE tablefunc_crosstab_4 AS34(35	row_name TEXT,36	category_1 TEXT,37	category_2 TEXT,38	category_3 TEXT,39	category_4 TEXT40);41 42CREATE FUNCTION crosstab2(text)43RETURNS setof tablefunc_crosstab_244AS 'MODULE_PATHNAME','crosstab'45LANGUAGE C STABLE STRICT;46 47CREATE FUNCTION crosstab3(text)48RETURNS setof tablefunc_crosstab_349AS 'MODULE_PATHNAME','crosstab'50LANGUAGE C STABLE STRICT;51 52CREATE FUNCTION crosstab4(text)53RETURNS setof tablefunc_crosstab_454AS 'MODULE_PATHNAME','crosstab'55LANGUAGE C STABLE STRICT;56 57-- obsolete:58CREATE FUNCTION crosstab(text,int)59RETURNS setof record60AS 'MODULE_PATHNAME','crosstab'61LANGUAGE C STABLE STRICT;62 63CREATE FUNCTION crosstab(text,text)64RETURNS setof record65AS 'MODULE_PATHNAME','crosstab_hash'66LANGUAGE C STABLE STRICT;67 68CREATE FUNCTION connectby(text,text,text,text,int,text)69RETURNS setof record70AS 'MODULE_PATHNAME','connectby_text'71LANGUAGE C STABLE STRICT;72 73CREATE FUNCTION connectby(text,text,text,text,int)74RETURNS setof record75AS 'MODULE_PATHNAME','connectby_text'76LANGUAGE C STABLE STRICT;77 78-- These 2 take the name of a field to ORDER BY as 4th arg (for sorting siblings)79 80CREATE FUNCTION connectby(text,text,text,text,text,int,text)81RETURNS setof record82AS 'MODULE_PATHNAME','connectby_text_serial'83LANGUAGE C STABLE STRICT;84 85CREATE FUNCTION connectby(text,text,text,text,text,int)86RETURNS setof record87AS 'MODULE_PATHNAME','connectby_text_serial'88LANGUAGE C STABLE STRICT;89