From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | 孤傲小二~阿沐 <2903807914(at)qq(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database |
Date: | 2021-11-12 04:23:41 |
Message-ID: | CAKFQuwYy2wEd-KZHvXiLM_e5nfTeA17n3fb4gHicq0Pv-KK=qg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Nov 11, 2021 at 8:42 PM 孤傲小二~阿沐 <2903807914(at)qq(dot)com> wrote:
> I added a √ operator to scan.l.
>
Why?
> The sqrt function is still used internally, but there is a problem now,
> which affects the := and .. operators of the database.
>
Someone else will have to volunteer their time to cover this learning curve
(I couldn't even if I wanted to). But given that what you are trying to
accomplish is not something we'd likely consider adding to the core server
(we created CREATE OPERATOR instead) that seems like a bit of an ask.
> # Description of Requirement:
> 1、select √ num1; function
> 2、The value of num1 is required to be: [0,9223372036854775807]
> 3、√ The operation does not allow decimals
>
Per 2 the value of num1 is a decimal yet per 3 the operation is required to
not allow decimals?
David J.