pgsql/contrib README tablefunc/Makefile tablef ...

Поиск
Список
Период
Сортировка
Искать

pgsql/contrib README tablefunc/Makefile tablef ...

От:
momjian@postgresql.org (Bruce Momjian - CVS)
Дата:
CVSROOT:	/cvsroot
Module name:	pgsql
Changes by:	momjian@postgresql.org	02/07/30 12:31:11

Modified files:
	contrib        : README 
Added files:
	contrib/tablefunc: Makefile README.tablefunc tablefunc-test.sql 
	                   tablefunc.c tablefunc.h tablefunc.sql.in 

Log message:
	As mentioned above, here is my contrib/tablefunc patch. It includes
	three functions which exercise the tablefunc API.
	
	show_all_settings()
	- returns the same information as SHOW ALL, but as a query result
	
	normal_rand(int numvals, float8 mean, float8 stddev, int seed)
	- returns a set of normally distributed float8 values
	- This routine implements Algorithm P (Polar method for normal
	deviates) from Knuth's _The_Art_of_Computer_Programming_, Volume 2,
	3rd ed., pages 122-126. Knuth cites his source as "The polar
	method", G. E. P. Box, M. E. Muller, and G. Marsaglia,
	_Annals_Math,_Stat._ 29 (1958), 610-611.
	
	crosstabN(text sql)
	- returns a set of row_name plus N category value columns
	- crosstab2(), crosstab3(), and crosstab4() are defined for you,
	but you can create additional crosstab functions per directions
	in the README.
	
	Joe Conway

FAQ