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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Nov 11, 2021 at 8:42 PM 孤傲小二～阿沐 <2903807914@xxxxxx> 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.