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

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 05:10:47
Message-ID: CAKFQuwbrvniChRouCkyurDMDrgWtUdkeM+kkPEEStQUVcbfScg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guessing here but try a different symbol, something in ASCII (I'm guessing
the current choice is not). The fact that you added your symbol directly
above dotdot and colonequals is suspicious...

David J.

On Thu, Nov 11, 2021, 21:32 孤傲小二~阿沐 <2903807914(at)qq(dot)com> wrote:

> Hello, thank you for your busy reply. The purpose of this development is
> to learn PostgreSQL's lexical parsing process in depth, and it has no
> substantial effect. You can ignore this. The limitation of the scene can
> also be ignored.
>
> The problem now is that select √ 1024; can be used normally, but it will
> affect the existing functions.
>
> I don’t know why this happened. Please forgive me for not clarifying my
> focus.
>
>
> ------------------ 原始邮件 ------------------
> *发件人:* "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>;
> *发送时间:* 2021年11月12日(星期五) 中午12:23
> *收件人:* "孤傲小二~阿沐"<2903807914(at)qq(dot)com>;
> *抄送:* "pgsql-general"<pgsql-general(at)lists(dot)postgresql(dot)org>;
> *主题:* 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
>
> 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.
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 孤傲小二~阿沐 2021-11-12 05:16:22 回复: 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 孤傲小二~阿沐 2021-11-12 04:32:52 回复: 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