sql - XOR between numeric in PostgreSQL -


So I have two integers & gt; 2 ^ 63 - 1 but & lt; 2 ^ 64-1 This is countless beginnings in most languages, but according to it, its numerical (20) problem in postogresql is

The problem is, when I make a postgrescle xor operation between two unsigned large digits Try: 

  Selection 17418945696623429624 :: Numerical (20) # 17418945696623429624 :: Numerical (20);   
 = & gt;  
  error: operator does not exist: numerical # numeric   
 Any non "numerical" integer less than 2 ^ 63 -1, it works fine Does.  
 Refresh: How do I perform XOR operations between two numbers, 2 numbers, 2 to 2 numbers, but less than 2 ^ 64 - 1? East. How can XOR 17418945696623429624 with yourself in PostgreSQL?   
 
 
 It seems - why do not you use it?

Comments

Post a Comment