Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

Tom Lane wrote:
> CVSROOT: /cvsroot
> Module name: pgsql-server
> Changes by: tgl(at)svr1(dot)postgresql(dot)org 03/09/07 12:26:54
>
> Modified files:
> doc/src/sgml : runtime.sgml
> src/backend/optimizer/geqo: geqo_main.c
> src/backend/utils/misc: guc.c postgresql.conf.sample
> src/bin/psql : tab-complete.c
> src/include/optimizer: geqo.h
>
> Log message:
> Remove geqo_random_seed parameter. Having geqo reset the global random()
> sequence every time it's called is bogus --- it interferes with user
> control over the seed, and actually decreases randomness overall
> (because a seed based on time(NULL) is pretty predictable). If you really
> want a reproducible result from geqo, do 'set seed = 0' before planning
> a query.

Tom, I see 'set seed' works:

test=> set seed = 0;
SET

but where is it documented?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073