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

From: 孤傲小二～阿沐 <2903807914(at)qq(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
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
Date: 2021-11-12 03:41:08
Message-ID: tencent_FB9EB101F09A687C499807EF813E946D4E0A@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone，

I added a √ operator to scan.l. The sqrt function is still used internally, but there is a problem now, which affects the := and .. operators of the database.

# 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

I have now developed this feature on the PostgreSQL 14.0 kernel! But it affects the original function of the database:

#&nbsp;Affected place
1、 := assignment operator
2、 Operator in 1..10

#&nbsp;Recurring problem
1、make check

Attachment Content-Type Size
sqrt_bigint.patch application/octet-stream 5.3 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2021-11-12 04:23:41 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
Previous Message Adrian Klaver 2021-11-12 01:41:01 Re: Pg_hba.conf problem after unexpected IP change