Return to cast.out CVS log

Up to [pgFoundry] / uint / uint / expected

Initial checking for the unsigned integer data type.

-- Valid uint1 casts.
SELECT 0::uint1;
 uint1 
-------
 0
(1 row)

SELECT 1::uint1;
 uint1 
-------
 1
(1 row)

SELECT 127::uint1;
 uint1 
-------
 127
(1 row)

SELECT 128::uint1;
 uint1 
-------
 128
(1 row)

SELECT 254::uint1;
 uint1 
-------
 254
(1 row)

SELECT 255::uint1;
 uint1 
-------
 255
(1 row)

-- Invalid uint1 casts (negative numbers)
SELECT -1::uint1;
 ?column? 
----------
       -1
(1 row)

SELECT -127::uint1;
 ?column? 
----------
     -127
(1 row)

SELECT -128::uint1;
 ?column? 
----------
     -128
(1 row)

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

SELECT -32767::uint1;
ERROR:  uint1 out of range
SELECT -32768::uint1;
ERROR:  uint1 out of range
SELECT -65535::uint1;
ERROR:  uint1 out of range
SELECT -65536::uint1;
ERROR:  uint1 out of range
SELECT -2147483647::uint1;
ERROR:  uint1 out of range
SELECT -2147483648::uint1;
ERROR:  cannot cast type bigint to uint1
LINE 1: SELECT -2147483648::uint1;
                            ^
SELECT -4294967295::uint1;
ERROR:  cannot cast type bigint to uint1
LINE 1: SELECT -4294967295::uint1;
                            ^
SELECT -4294967296::uint1;
ERROR:  cannot cast type bigint to uint1
LINE 1: SELECT -4294967296::uint1;
                            ^
-- Invalid uint1 casts (out of range)
SELECT 256::uint1;
ERROR:  uint1 out of range
SELECT 32767::uint1;
ERROR:  uint1 out of range
SELECT 32768::uint1;
ERROR:  uint1 out of range
SELECT 65535::uint1;
ERROR:  uint1 out of range
SELECT 65536::uint1;
ERROR:  uint1 out of range
SELECT 2147483647::uint1;
ERROR:  uint1 out of range
SELECT 2147483648::uint1;
ERROR:  cannot cast type bigint to uint1
LINE 1: SELECT 2147483648::uint1;
                           ^
SELECT 4294967295::uint1;
ERROR:  cannot cast type bigint to uint1
LINE 1: SELECT 4294967295::uint1;
                           ^
SELECT 4294967296::uint1;
ERROR:  cannot cast type bigint to uint1
LINE 1: SELECT 4294967296::uint1;
                           ^
-- Valid uint2 casts.
SELECT 0::uint2;
 uint2 
-------
 0
(1 row)

SELECT 1::uint2;
 uint2 
-------
 1
(1 row)

SELECT 127::uint2;
 uint2 
-------
 127
(1 row)

SELECT 128::uint2;
 uint2 
-------
 128
(1 row)

SELECT 254::uint2;
 uint2 
-------
 254
(1 row)

SELECT 255::uint2;
 uint2 
-------
 255
(1 row)

SELECT 32767::uint2;
 uint2 
-------
 32767
(1 row)

SELECT 32768::uint2;
 uint2 
-------
 32768
(1 row)

SELECT 65535::uint2;
 uint2 
-------
 65535
(1 row)

-- Invalid uint2 casts (negative numbers)
SELECT -1::uint2;
 ?column? 
----------
       -1
(1 row)

SELECT -127::uint2;
 ?column? 
----------
     -127
(1 row)

SELECT -128::uint2;
 ?column? 
----------
     -128
(1 row)

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

SELECT -32767::uint2;
 ?column? 
----------
   -32767
(1 row)

SELECT -32768::uint2;
 ?column? 
----------
   -32768
(1 row)

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

SELECT -65536::uint2;
ERROR:  unsigned smallint out of range
SELECT -2147483647::uint2;
ERROR:  unsigned smallint out of range
SELECT -2147483648::uint2;
ERROR:  cannot cast type bigint to uint2
LINE 1: SELECT -2147483648::uint2;
                            ^
SELECT -4294967295::uint2;
ERROR:  cannot cast type bigint to uint2
LINE 1: SELECT -4294967295::uint2;
                            ^
SELECT -4294967296::uint2;
ERROR:  cannot cast type bigint to uint2
LINE 1: SELECT -4294967296::uint2;
                            ^
-- Invalid uint2 casts (out of range)
SELECT 2147483647::uint2;
ERROR:  unsigned smallint out of range
SELECT 2147483648::uint2;
ERROR:  cannot cast type bigint to uint2
LINE 1: SELECT 2147483648::uint2;
                           ^
SELECT 4294967295::uint2;
ERROR:  cannot cast type bigint to uint2
LINE 1: SELECT 4294967295::uint2;
                           ^
SELECT 4294967296::uint2;
ERROR:  cannot cast type bigint to uint2
LINE 1: SELECT 4294967296::uint2;
                           ^
-- Valid uint4 casts.
SELECT 0::uint4;
 uint4 
-------
 0
(1 row)

SELECT 1::uint4;
 uint4 
-------
 1
(1 row)

SELECT 127::uint4;
 uint4 
-------
 127
(1 row)

SELECT 128::uint4;
 uint4 
-------
 128
(1 row)

SELECT 254::uint4;
 uint4 
-------
 254
(1 row)

SELECT 255::uint4;
 uint4 
-------
 255
(1 row)

SELECT 32767::uint4;
 uint4 
-------
 32767
(1 row)

SELECT 32768::uint4;
 uint4 
-------
 32768
(1 row)

SELECT 65535::uint4;
 uint4 
-------
 65535
(1 row)

SELECT 65536::uint4;
 uint4 
-------
 65536
(1 row)

SELECT 2147483647::uint4;
   uint4    
------------
 2147483647
(1 row)

SELECT 2147483648::uint4;
   uint4    
------------
 2147483648
(1 row)

SELECT 4294967295::uint4;
   uint4    
------------
 4294967295
(1 row)

-- Invalid uint4 casts (negative numbers)
SELECT -1::uint4;
 ?column? 
----------
       -1
(1 row)

SELECT -127::uint4;
 ?column? 
----------
     -127
(1 row)

SELECT -128::uint4;
 ?column? 
----------
     -128
(1 row)

SELECT -255::uint4;
 ?column? 
----------
     -255
(1 row)

SELECT -32767::uint4;
 ?column? 
----------
   -32767
(1 row)

SELECT -32768::uint4;
 ?column? 
----------
   -32768
(1 row)

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

SELECT -65536::uint4;
 ?column? 
----------
   -65536
(1 row)

SELECT -2147483647::uint4;
  ?column?   
-------------
 -2147483647
(1 row)

SELECT -2147483648::uint4;
  ?column?   
-------------
 -2147483648
(1 row)

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

SELECT -4294967296::uint4;
ERROR:  unsigned integer out of range
-- Invalid uint4 casts (out of range)
SELECT 4294967296::uint4;
ERROR:  unsigned integer out of range