diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-07-30 16:31:11 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-07-30 16:31:11 +0000 |
| commit | 41f862ba8766fd2cee7c3f939c4adf84e2b7b218 (patch) | |
| tree | ace39087c92cfa216933cc306d388f4235b6c9d2 /contrib/README | |
| parent | 23a8b77d42463437f1dd52c601bcfeb858aef7b3 (diff) | |
| download | postgresql-41f862ba8766fd2cee7c3f939c4adf84e2b7b218.tar.gz | |
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
Diffstat (limited to 'contrib/README')
| -rw-r--r-- | contrib/README | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/README b/contrib/README index 6ae9b2851c..3bb2883677 100644 --- a/contrib/README +++ b/contrib/README @@ -186,6 +186,10 @@ string - C-like input/output conversion routines for strings by Massimo Dal Zotto <dz@cs.unitn.it> +tablefunc - + Examples of tables returning functions + by Joe Conway <mail@joeconway.com> + tips/apache_logging - Getting Apache to log to PostgreSQL by Terry Mackintosh <terry@terrym.com> |