Re: [PATCH] random_normal function - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] random_normal function
Date
Msg-id Y5/cOTNO4YwmY5e9@paquier.xyz
Whole thread Raw
In response to Re: [PATCH] random_normal function  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: [PATCH] random_normal function  (Fabien COELHO <coelho@cri.ensmp.fr>)
Re: [PATCH] random_normal function  (Vik Fearing <vik@postgresfriends.org>)
List pgsql-hackers
On Sat, Dec 17, 2022 at 05:49:15PM +0100, Fabien COELHO wrote:
> 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.

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.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUG] pg_upgrade test fails from older versions.
Next
From: Michael Paquier
Date:
Subject: Re: Add LZ4 compression in pg_dump