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

Tom Lane wrote:
> CVSROOT:    /cvsroot
> Module name:    pgsql-server
> Changes by:    tgl@svr1.postgresql.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073