Postgres Pro
Downloads
Home   >   mailing lists

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 - Mailing list pgsql-general

From David G. Johnston
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
Msg-id CAKFQuwYy2wEd-KZHvXiLM_e5nfTeA17n3fb4gHicq0Pv-KK=qg@mail.gmail.com
Whole thread Raw
In response to 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  ("孤傲小二～阿沐" <2903807914@qq.com>)
List pgsql-general
Tree view
On Thu, Nov 11, 2021 at 8:42 PM 孤傲小二～阿沐 <2903807914@qq.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.

pgsql-general by date:

Previous
From: "孤傲小二～阿沐"
Date:
Subject: 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
Next
From: "孤傲小二～阿沐"
Date:
Subject: 回复： 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