Re: random() function documentation - Mailing list pgsql-hackers

From Dagfinn Ilmari Mannsåker
Subject Re: random() function documentation
Date
Msg-id 87wnfunxo9.fsf@wibble.ilmari.org
Whole thread Raw
In response to random() function documentation  (Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>)
Responses Re: random() function documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:

> On Mon, 11 Apr 2022 at 20:20, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> >> How about we just say "uses a linear-feedback shift register algorithm"?
>
> I think it'd be sufficient to just say that it's a deterministic
> pseudorandom number generator. I don't see much value in documenting
> the internal algorithm used.
>
>> > Should we
>> > perhaps also add a warning that the same seed is not guaranteed to
>> > produce the same sequence across different (major?) versions?
>>
>> I wouldn't bother, on the grounds that then we'd need such disclaimers
>> in a whole lot of places.  Others might see it differently though.
>
> Agreed, though I think when the release notes are written, they ought
> to warn that the sequence will change with this release.

WFM on both points.

> Regards,
> Dean

- ilmari



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: random() function documentation
Next
From: Tom Lane
Date:
Subject: Re: How about a psql backslash command to show GUCs?