Re: New function normal_rand_array function to contrib/tablefunc.

From: Andy Fan <zhihuifan1213(at)163(dot)com>
To: Japin Li <japinli(at)hotmail(dot)com>
Cc: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: New function normal_rand_array function to contrib/tablefunc.
Date: 2024-08-29 04:38:57
Message-ID: 87ed68gcym.fsf@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Japin Li <japinli(at)hotmail(dot)com> writes:

> On Wed, 28 Aug 2024 at 12:27, Andy Fan <zhihuifan1213(at)163(dot)com> wrote:
>> Japin Li <japinli(at)hotmail(dot)com> writes:
>>
> Nitpick, the minlen is smaller than maxlen, so the maxlen cannot be zero.
>
> After giving it some more thought, it would also be helpful if maxlen is
> equal to minlen.
>
> For example, I want have each row has four items, I can use the following
>
> SELECT rand_array(10, 4, 4, 50::int, 80::int);

Yes, that's a valid usage. the new vesion is attached. I have changed
the the commit entry [1] from "Waiting on Author" to "Needs review".

> OTOH, I find the range bound uses "less than or equal to", how about
> replacing "smaller" with "less"?

--
Best Regards
Andy Fan

Attachment Content-Type Size
v20240829-0001-Add-functions-rand_array-function-to-contr.patch text/x-diff 12.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2024-08-29 04:49:50 Re: Conflict Detection and Resolution
Previous Message Andy Fan 2024-08-29 04:30:44 Re: Parallel CREATE INDEX for GIN indexes