Am 24.07.22 um 21:42 schrieb Fabien COELHO:
>
> Duno. I'm still wondering what it should do. I'm pretty sure that the
> documentation should be clear about a shared seed, if any. I do not
> think that departing from the standard is a good thing, either.
Are sure it violates the standard? I could not find anything about it.
The private prng state for random() was introduced in 2018 [0]. Neither
commit nor discussion mentions any standard compliance.
[0]
https://www.postgresql.org/message-id/E1gdNAo-00036g-TB%40gemulon.postgresql.org
I updated the documentation for setseed().
> If someone wants a limit, they can easily "LEAST(#1 dim size, other
> limit)" to get it, it is easy enough with a strict function.
Convinced. It errors out now if n is out of bounds.
Martin