Bonjour Michaël,
>> Overall, I think that there should be a clearer discussion and plan about
>> which random functionS postgres should provide to complement the standard
>> instead of going there… randomly:-)
>
> So, what does the specification tells about seeds, normal and random
> functions? A bunch of DBMSs implement RAND, sometimes RANDOM, SEED or
> even NORMAL using from time to time specific SQL keywords to do the
> work.
I do not have the SQL standard, so I have no idea about what is in there.
From a typical use case point of view, I'd say uniform, normal and
exponential would make sense for floats. I'm also okay with generating a
uniform bytes pseudo-randomly.
I'd be more at ease to add simple functions rather than a special
heavy-on-keywords syntax, even if standard.
> Note that SQLValueFunction made the addition of more returning data
> types a bit more complicated (not much, still) than the new
> COERCE_SQL_SYNTAX by going through a mapping function, so the
> keyword/function mapping is straight-forward.
I'm unclear about why this paragraph is here.
--
Fabien.