From: | "Martin L(dot) Buchanan" <martinlbuchanan(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | integer square root function proposed |
Date: | 2022-12-18 02:39:44 |
Message-ID: | CAPfd9Mm5rh3TfW_frM4q7tmidM39_ezBQuYJXXf8ff6Y8_jSCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear PostgreSQL colleagues:
I have just joined this, my first PG mailing list.
Reading the documentation I found no built-in function for integer square
root, requiring a sequence of:
floor(sqrt(foo))::integer
to go from an integer to the integer square root as an integer.
If PG leaders smile on this suggestion, could we have *isqrt*(foo) where
foo has a numeric type and the result type is the same numeric type, with
the result type being the integer square root for foo >= 0 and producing an
error if negative? (And with infinities and NaNs processed as described in
8.1 Numeric Types).
I did not see an explicit enhancement request list in the PG mailing lists.
Recommendations for a more specific list to post this to are welcome.
Sincerely,
Martin L. Buchanan
software developer
Laramie, WY, USA
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2022-12-18 03:20:21 | Re: integer square root function proposed |
Previous Message | Michael Arnold | 2022-12-18 01:15:28 | Re: Postgres Date Type Value |