Search Postgresql Archives

=?gb18030?b?u9i4tKO6IEkgYWRkZWQgYSChzCBvcGVyYXRvciwg?==?gb18030?b?dGhlIHNxcnQgZnVuY3Rpb24gaXMgc3RpbGwgdXNl?==?gb18030?b?ZCBpbnRlcm5hbGx5LCBidXQgbm93IHRoZXJlIGlz?==?gb18030?b?IGEgcHJvYmxlbSwgaXQgYWZmZWN0cyB0aGUgOj0g?==?gb18030?b?YW5kIC4uIG9wZXJhdG9ycyBvZiB0aGUgZGF0YWJh?==?gb18030?b?c2U=?=

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello, do you mean there is a problem with this symbol itself? But so far, there are no problems when using it.

sqrt "√"

So where do you think this should be added? I tried to change the position but the error still persists


------------------ 原始邮件 ------------------
发件人: "David G. Johnston" <david.g.johnston@xxxxxxxxx>;
发送时间: 2021年11月12日(星期五) 中午1:10
收件人: "孤傲小二~阿沐"<2903807914@xxxxxx>;
抄送: "pgsql-general"<pgsql-general@xxxxxxxxxxxxxxxxxxxx>;
主题: 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

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@xxxxxx> 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.g.johnston@xxxxxxxxx>;
发送时间: 2021年11月12日(星期五) 中午12:23
收件人: "孤傲小二~阿沐"<2903807914@xxxxxx>;
抄送: "pgsql-general"<pgsql-general@xxxxxxxxxxxxxxxxxxxx>;
主题: 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@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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux