Return to bit_ops.out CVS log

Up to [pgFoundry] / uint / uint / expected

Initial checking for the unsigned integer data type.

-- uint1 bit operations
SELECT 0::uint1 & 15::uint1;
 ?column? 
----------
 0
(1 row)

SELECT 85::uint1 & 15::uint1;
 ?column? 
----------
 5
(1 row)

SELECT 170::uint1 & 15::uint1;
 ?column? 
----------
 10
(1 row)

SELECT 255::uint1 & 15::uint1;
 ?column? 
----------
 15
(1 row)

SELECT 0::uint1 | 85::uint1;
 ?column? 
----------
 85
(1 row)

SELECT 85::uint1 | 170::uint1;
 ?column? 
----------
 255
(1 row)

SELECT 0::uint1 | 255::uint1;
 ?column? 
----------
 255
(1 row)

SELECT 0::uint1 | 85::uint1;
 ?column? 
----------
 85
(1 row)

SELECT 85::uint1 | 170::uint1;
 ?column? 
----------
 255
(1 row)

SELECT 0::uint1 | 255::uint1;
 ?column? 
----------
 255
(1 row)

SELECT 0::uint1 # 85::uint1;
 ?column? 
----------
 85
(1 row)

SELECT 85::uint1 # 170::uint1;
 ?column? 
----------
 255
(1 row)

SELECT 0::uint1 # 255::uint1;
 ?column? 
----------
 255
(1 row)

SELECT ~0::uint1;
 ?column? 
----------
 255
(1 row)

SELECT ~170::uint1;
 ?column? 
----------
 85
(1 row)

SELECT ~255::uint1;
 ?column? 
----------
 0
(1 row)

SELECT 0::uint1 >> 4;
 ?column? 
----------
 0
(1 row)

SELECT 170::uint1 >> 4;
 ?column? 
----------
 10
(1 row)

SELECT 255::uint1 >> 4;
 ?column? 
----------
 15
(1 row)

SELECT 0::uint1 << 4;
 ?column? 
----------
 0
(1 row)

SELECT 170::uint1 << 4;
 ?column? 
----------
 160
(1 row)

SELECT 255::uint1 << 4;
 ?column? 
----------
 240
(1 row)

-- uint2 comparision operations
SELECT 0::uint2 & 255::uint2;
 ?column? 
----------
 0
(1 row)

SELECT 21845::uint2 & 255::uint2;
 ?column? 
----------
 85
(1 row)

SELECT 43690::uint2 & 255::uint2;
 ?column? 
----------
 170
(1 row)

SELECT 65535::uint2 & 255::uint2;
 ?column? 
----------
 255
(1 row)

SELECT 0::uint2 | 21845::uint2;
 ?column? 
----------
 21845
(1 row)

SELECT 21845::uint2 | 43690::uint2;
 ?column? 
----------
 65535
(1 row)

SELECT 0::uint2 | 65535::uint2;
 ?column? 
----------
 65535
(1 row)

SELECT 0::uint2 # 21845::uint2;
 ?column? 
----------
 21845
(1 row)

SELECT 21845::uint2 # 43690::uint2;
 ?column? 
----------
 65535
(1 row)

SELECT 0::uint2 # 65535::uint2;
 ?column? 
----------
 65535
(1 row)

SELECT ~0::uint2;
 ?column? 
----------
 65535
(1 row)

SELECT ~43690::uint2;
 ?column? 
----------
 21845
(1 row)

SELECT ~65535::uint2;
 ?column? 
----------
 0
(1 row)

SELECT 0::uint2 >> 8;
 ?column? 
----------
 0
(1 row)

SELECT 43690::uint2 >> 8;
 ?column? 
----------
 170
(1 row)

SELECT 65535::uint2 >> 8;
 ?column? 
----------
 255
(1 row)

SELECT 0::uint2 << 8;
 ?column? 
----------
 0
(1 row)

SELECT 43690::uint2 << 8;
 ?column? 
----------
 43520
(1 row)

SELECT 65535::uint2 << 8;
 ?column? 
----------
 65280
(1 row)

-- uint4 comparision operations
SELECT 0::uint4 & 65535::uint4;
 ?column? 
----------
 0
(1 row)

SELECT 1431655767::uint4 & 65535::uint4;
 ?column? 
----------
 21847
(1 row)

SELECT 2863311530::uint4 & 65535::uint4;
 ?column? 
----------
 43690
(1 row)

SELECT 4294967295::uint4 & 65535::uint4;
 ?column? 
----------
 65535
(1 row)

SELECT 0::uint4 | 1431655767::uint4;
  ?column?  
------------
 1431655767
(1 row)

SELECT 1431655767::uint4 | 2863311530::uint4;
  ?column?  
------------
 4294967295
(1 row)

SELECT 0::uint4 | 4294967295::uint4;
  ?column?  
------------
 4294967295
(1 row)

SELECT 0::uint4 # 1431655767::uint4;
  ?column?  
------------
 1431655767
(1 row)

SELECT 1431655767::uint4 # 2863311530::uint4;
  ?column?  
------------
 4294967293
(1 row)

SELECT 0::uint4 # 4294967295::uint4;
  ?column?  
------------
 4294967295
(1 row)

SELECT ~0::uint4;
  ?column?  
------------
 4294967295
(1 row)

SELECT ~2863311530::uint4;
  ?column?  
------------
 1431655765
(1 row)

SELECT ~4294967295::uint4;
 ?column? 
----------
 0
(1 row)

SELECT 0::uint4 >> 16;
 ?column? 
----------
 0
(1 row)

SELECT 2863311530::uint4 >> 16;
 ?column? 
----------
 43690
(1 row)

SELECT 4294967295::uint4 >> 16;
 ?column? 
----------
 65535
(1 row)

SELECT 0::uint4 << 16;
 ?column? 
----------
 0
(1 row)

SELECT 2863311530::uint4 << 16;
  ?column?  
------------
 2863267840
(1 row)

SELECT 4294967295::uint4 << 16;
  ?column?  
------------
 4294901760
(1 row)