home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,197 of 2,288   
   Terry Coccoli to All   
   Bitand Question   
   05 Mar 04 21:53:53   
   
   From: request@ifneeded.com   
      
   Can someone tell me if the following query:   
      
   select bitand(power(2,31),power(2,30))+0   
   from dual   
      
      
   which returns 1073741824 is correct ? I'm thinking that the result   
   should actually be 0.   
      
      
      
   When I run   
      
   select bitand(power(2,30),power(2,29))+0   
   from dual   
      
      
      
   I get 0, as expected.  Am I running into a limitation of the bitand   
   function ?  Is there any documentation on this function?   
      
      
   Thanks.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca