Return to insert.out CVS log

Up to [pgFoundry] / uint / uint / expected

Initial checking for the unsigned integer data type.

-- Create table.
CREATE TABLE uint_insert_test (
   col1 uint4 NOT NULL,
   col2 uint2 NOT NULL,
   col3 uint1 NOT NULL
) WITHOUT OIDS;
-- Load data
INSERT INTO uint_insert_test VALUES (4294967295, 65535, 255);
INSERT INTO uint_insert_test VALUES (4294967295::uint4, 65535::uint2, 255::uint1);
INSERT INTO uint_insert_test VALUES (2147483648, 32768, 128);
INSERT INTO uint_insert_test VALUES (2147483648::uint4, 32768::uint2, 128::uint1);
INSERT INTO uint_insert_test VALUES (2147483647, 32767, 127);
INSERT INTO uint_insert_test VALUES (2147483647::uint4, 32767::uint2, 127::uint1);
INSERT INTO uint_insert_test VALUES (65536, 256, 64);
INSERT INTO uint_insert_test VALUES (65536::uint4, 256::uint2, 64::uint1);
INSERT INTO uint_insert_test VALUES (65535, 255, 63);
INSERT INTO uint_insert_test VALUES (65535::uint4, 255::uint2, 63::uint1);
INSERT INTO uint_insert_test VALUES (32768, 128, 32);
INSERT INTO uint_insert_test VALUES (32768::uint4, 128::uint2, 32::uint1);
INSERT INTO uint_insert_test VALUES (32767, 127, 31);
INSERT INTO uint_insert_test VALUES (32767::uint4, 127::uint2, 31::uint1);
INSERT INTO uint_insert_test VALUES (256, 64, 16);
INSERT INTO uint_insert_test VALUES (256::uint4, 64::uint2, 16::uint1);
INSERT INTO uint_insert_test VALUES (255, 63, 15);
INSERT INTO uint_insert_test VALUES (255::uint4, 63::uint2, 15::uint1);
INSERT INTO uint_insert_test VALUES (128, 32, 8);
INSERT INTO uint_insert_test VALUES (128::uint4, 32::uint2, 8::uint1);
INSERT INTO uint_insert_test VALUES (127, 31, 7);
INSERT INTO uint_insert_test VALUES (127::uint4, 31::uint2, 7::uint1);
INSERT INTO uint_insert_test VALUES (64, 16, 4);
INSERT INTO uint_insert_test VALUES (64::uint4, 16::uint2, 4::uint1);
INSERT INTO uint_insert_test VALUES (63, 15, 3);
INSERT INTO uint_insert_test VALUES (63::uint4, 15::uint2, 3::uint1);
INSERT INTO uint_insert_test VALUES (32, 8, 2);
INSERT INTO uint_insert_test VALUES (32::uint4, 8::uint2, 2::uint1);
INSERT INTO uint_insert_test VALUES (31, 7, 1);
INSERT INTO uint_insert_test VALUES (31::uint4, 7::uint2, 1::uint1);
INSERT INTO uint_insert_test VALUES (16, 4, 0);
INSERT INTO uint_insert_test VALUES (16::uint4, 4::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (15, 3, 0);
INSERT INTO uint_insert_test VALUES (15::uint4, 3::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (8, 2, 0);
INSERT INTO uint_insert_test VALUES (8::uint4, 2::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (7, 1, 0);
INSERT INTO uint_insert_test VALUES (7::uint4, 1::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (4, 0, 0);
INSERT INTO uint_insert_test VALUES (4::uint4, 0::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (3, 0, 0);
INSERT INTO uint_insert_test VALUES (3::uint4, 0::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (2, 0, 0);
INSERT INTO uint_insert_test VALUES (2::uint4, 0::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (1, 0, 0);
INSERT INTO uint_insert_test VALUES (1::uint4, 0::uint2, 0::uint1);
INSERT INTO uint_insert_test VALUES (0, 0, 0);
INSERT INTO uint_insert_test VALUES (0::uint4, 0::uint2, 0::uint1);
-- Verify data.
SELECT col3, col2, col1
FROM   uint_insert_test
ORDER BY col1;
 col3 | col2  |    col1    
------+-------+------------
 0    | 0     | 0
 0    | 0     | 0
 0    | 0     | 1
 0    | 0     | 1
 0    | 0     | 2
 0    | 0     | 2
 0    | 0     | 3
 0    | 0     | 3
 0    | 0     | 4
 0    | 0     | 4
 0    | 1     | 7
 0    | 1     | 7
 0    | 2     | 8
 0    | 2     | 8
 0    | 3     | 15
 0    | 3     | 15
 0    | 4     | 16
 0    | 4     | 16
 1    | 7     | 31
 1    | 7     | 31
 2    | 8     | 32
 2    | 8     | 32
 3    | 15    | 63
 3    | 15    | 63
 4    | 16    | 64
 4    | 16    | 64
 7    | 31    | 127
 7    | 31    | 127
 8    | 32    | 128
 8    | 32    | 128
 15   | 63    | 255
 15   | 63    | 255
 16   | 64    | 256
 16   | 64    | 256
 31   | 127   | 32767
 31   | 127   | 32767
 32   | 128   | 32768
 32   | 128   | 32768
 63   | 255   | 65535
 63   | 255   | 65535
 64   | 256   | 65536
 64   | 256   | 65536
 127  | 32767 | 2147483647
 127  | 32767 | 2147483647
 128  | 32768 | 2147483648
 128  | 32768 | 2147483648
 255  | 65535 | 4294967295
 255  | 65535 | 4294967295
(48 rows)