From: | momjian(at)postgresql(dot)org (Bruce Momjian - CVS) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql/contrib README tablefunc/Makefile tablef ... |
Date: | 2002-07-30 16:31:11 |
Message-ID: | 20020730163111.AC4D3475BD1@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
CVSROOT: /cvsroot
Module name: pgsql
Changes by: momjian(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian - CVS | 2002-07-30 16:32:20 | pgsql/contrib Makefile |
Previous Message | Bruce Momjian - CVS | 2002-07-30 16:28:12 | pgsql/contrib/tablefunc |