?????? 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

[??????????????]

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.johns...@gmail.com&gt;;
????????:&nbsp;2021??11??12??(??????) ????1:10
??????:&nbsp;"??????????????"<2903807...@qq.com&gt;;
????:&nbsp;"pgsql-general"<pgsql-general@lists.postgresql.org&gt;;
????:&nbsp;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).&nbsp; The fact that you added your symbol directly 
above dotdot and colonequals is suspicious...

David J.


On Thu, Nov 11, 2021, 21:32 ?????????????? <2903807...@qq.com&gt; 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.johns...@gmail.com&gt;;
????????:&nbsp;2021??11??12??(??????) ????12:23
??????:&nbsp;"??????????????"<2903807...@qq.com&gt;;
????:&nbsp;"pgsql-general"<pgsql-general@lists.postgresql.org&gt;;
????:&nbsp;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 ?????????????? <2903807...@qq.com&gt; wrote:


I added a ?? operator to scan.l.


Why?

&nbsp;
 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).&nbsp; 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.