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

From Michael Paquier
Subject Re: [PATCH] random_normal function
Date
Msg-id Y6PDOq83Gs349cE8@paquier.xyz
Whole thread Raw
In response to Re: [PATCH] random_normal function  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
On Wed, Dec 21, 2022 at 08:47:32AM +0100, Fabien COELHO wrote:
> 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 agree with this set.

> I'd be more at ease to add simple functions rather than a special
> heavy-on-keywords syntax, even if standard.

Okay.

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

Just saying that using COERCE_SQL_SYNTAX for SQL keywords is easier
than the older style.  If the SQL specification mentions no SQL
keywords for such things, this is irrelevant, of course :)
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Optimization issue of branching UNION ALL
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Inconsistency in reporting checkpointer stats