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"
<[email protected]>;
????????: 2021??11??12??(??????) ????12:23
??????: "??????????????"<[email protected]>;
????: "pgsql-general"<[email protected]>;
????: 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 ?????????????? <[email protected]> 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.