summaryrefslogtreecommitdiff
path: root/contrib/tablefunc/README.tablefunc
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-09-13 21:44:50 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-09-13 21:44:50 +0000
commitc472b8366f5bec1da4d5d5b894f47508bbc8d5d6 (patch)
tree26615ebe830975a50b1698dece1286e1adecaa52 /contrib/tablefunc/README.tablefunc
parent94a13b8a117c134a18ae37764c5524874b479db2 (diff)
downloadpostgresql-c472b8366f5bec1da4d5d5b894f47508bbc8d5d6.tar.gz
With Joe Conway's concurrence, remove srandom() call from normal_rand().
This was the last piece of code that took it upon itself to reset the random number sequence --- now we only have srandom() in postmaster start, backend start, and explicit setseed() operations.
Diffstat (limited to 'contrib/tablefunc/README.tablefunc')
-rw-r--r--contrib/tablefunc/README.tablefunc11
1 files changed, 4 insertions, 7 deletions
diff --git a/contrib/tablefunc/README.tablefunc b/contrib/tablefunc/README.tablefunc
index b80899e957..ddae931319 100644
--- a/contrib/tablefunc/README.tablefunc
+++ b/contrib/tablefunc/README.tablefunc
@@ -48,7 +48,7 @@ Installation:
installs following functions into database template1:
- normal_rand(int numvals, float8 mean, float8 stddev, int seed)
+ normal_rand(int numvals, float8 mean, float8 stddev)
- returns a set of normally distributed float8 values
crosstabN(text sql)
@@ -74,12 +74,12 @@ Documentation
==================================================================
Name
-normal_rand(int, float8, float8, int) - returns a set of normally
+normal_rand(int, float8, float8) - returns a set of normally
distributed float8 values
Synopsis
-normal_rand(int numvals, float8 mean, float8 stddev, int seed)
+normal_rand(int numvals, float8 mean, float8 stddev)
Inputs
@@ -92,9 +92,6 @@ Inputs
stddev
the standard deviation of the normal distribution of values
- seed
- a seed value for the pseudo-random number generator
-
Outputs
Returns setof float8, where the returned set of random values are normally
@@ -103,7 +100,7 @@ Outputs
Example usage
test=# SELECT * FROM
- test=# normal_rand(1000, 5, 3, EXTRACT(SECONDS FROM CURRENT_TIME(0))::int);
+ test=# normal_rand(1000, 5, 3);
normal_rand
----------------------
1.56556322244898