uint/uint/expected/comparision_ops.out - view

Return to comparision_ops.out CVS log

Up to [pgFoundry] / uint / uint / expected

File: [pgFoundry] / uint / uint / expected / comparision_ops.out (download)

Revision 1.1, Mon Sep 29 04:53:59 2008 UTC (23 months ago) by rbrad
Branch: MAIN
CVS Tags: HEAD

Initial checking for the unsigned integer data type.

-- uint1 comparision operations
SELECT btuint1cmp(10::uint1, 11::uint1);
 btuint1cmp 
------------
         -1
(1 row)

SELECT btuint1cmp(10::uint1, 10::uint1);
 btuint1cmp 
------------
          0
(1 row)

SELECT btuint1cmp(11::uint1, 10::uint1);
 btuint1cmp 
------------
          1
(1 row)

SELECT 10::uint1 = 10::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 10::uint1 = 100::uint1;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint1 <> 80::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 50::uint1 <> 50::uint1;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint1 < 80::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint1 < 70::uint1;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint1 < 60::uint1;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint1 <= 80::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint1 <= 70::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint1 <= 60::uint1;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint1 > 70::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint1 > 70::uint1;
 ?column? 
----------
 f
(1 row)

SELECT 60::uint1 > 70::uint1;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint1 >= 70::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint1 >= 70::uint1;
 ?column? 
----------
 t
(1 row)

SELECT 60::uint1 >= 70::uint1;
 ?column? 
----------
 f
(1 row)

-- uint2 comparision operations
SELECT btuint2cmp(10::uint2, 11::uint2);
 btuint2cmp 
------------
         -1
(1 row)

SELECT btuint2cmp(10::uint2, 10::uint2);
 btuint2cmp 
------------
          0
(1 row)

SELECT btuint2cmp(11::uint2, 10::uint2);
 btuint2cmp 
------------
          1
(1 row)

SELECT 10::uint2 = 10::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 10::uint2 = 100::uint2;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint2 <> 80::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 50::uint2 <> 50::uint2;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint2 < 80::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint2 < 70::uint2;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint2 < 60::uint2;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint2 <= 80::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint2 <= 70::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint2 <= 60::uint2;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint2 > 70::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint2 > 70::uint2;
 ?column? 
----------
 f
(1 row)

SELECT 60::uint2 > 70::uint2;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint2 >= 70::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint2 >= 70::uint2;
 ?column? 
----------
 t
(1 row)

SELECT 60::uint2 >= 70::uint2;
 ?column? 
----------
 f
(1 row)

-- uint4 comparision operations
SELECT btuint2cmp(10::uint4, 11::uint4);
ERROR:  function btuint2cmp(uint4, uint4) does not exist
LINE 1: SELECT btuint2cmp(10::uint4, 11::uint4);
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT btuint2cmp(10::uint4, 10::uint4);
ERROR:  function btuint2cmp(uint4, uint4) does not exist
LINE 1: SELECT btuint2cmp(10::uint4, 10::uint4);
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT btuint2cmp(11::uint4, 10::uint4);
ERROR:  function btuint2cmp(uint4, uint4) does not exist
LINE 1: SELECT btuint2cmp(11::uint4, 10::uint4);
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SELECT 10::uint4 = 10::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 10::uint4 = 100::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint4 <> 80::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 50::uint4 <> 50::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint4 < 80::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 < 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint4 < 60::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint4 <= 80::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 <= 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 <= 60::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint4 > 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 > 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 60::uint4 > 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint4 >= 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 >= 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 60::uint4 >= 70::uint4;
 ?column? 
----------
 f
(1 row)

-- int4 - uint4 comparision operations
SELECT 10::int4 = 10::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 10::int4 = 100::uint4;
 ?column? 
----------
 f
(1 row)

SELECT -1::int4 = 100::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 70::int4 <> 80::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 50::int4 <> 50::uint4;
 ?column? 
----------
 f
(1 row)

SELECT -1::int4 <> 50::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::int4 < 80::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::int4 < 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 70::int4 < 60::uint4;
 ?column? 
----------
 f
(1 row)

SELECT -1::int4 < 50::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::int4 <= 80::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::int4 <= 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::int4 <= 60::uint4;
 ?column? 
----------
 f
(1 row)

SELECT -1::int4 <= 50::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 80::uint4 > 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 > 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 60::uint4 > 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT -1::uint4 > 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint4 >= 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 >= 70::uint4;
 ?column? 
----------
 t
(1 row)

SELECT 60::uint4 >= 70::uint4;
 ?column? 
----------
 f
(1 row)

SELECT -1::uint4 >= 70::uint4;
 ?column? 
----------
 f
(1 row)

-- uint4 - int4 comparision operations
SELECT 10::uint4 = 10::int4;
 ?column? 
----------
 t
(1 row)

SELECT 10::uint4 = 100::int4;
 ?column? 
----------
 f
(1 row)

SELECT 100::uint4 = -1::int4;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint4 <> 80::int4;
 ?column? 
----------
 t
(1 row)

SELECT 50::uint4 <> 50::int4;
 ?column? 
----------
 f
(1 row)

SELECT 50::uint4 <> -1::int4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 < 80::int4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 < 70::int4;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint4 < 60::int4;
 ?column? 
----------
 f
(1 row)

SELECT 60::uint4 < -1::int4;
 ?column? 
----------
 f
(1 row)

SELECT 70::uint4 <= 80::int4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 <= 70::int4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 <= 60::int4;
 ?column? 
----------
 f
(1 row)

SELECT 60::uint4 <= -1::int4;
 ?column? 
----------
 f
(1 row)

SELECT 80::uint4 > 70::int4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 > 70::int4;
 ?column? 
----------
 f
(1 row)

SELECT 60::uint4 > 70::int4;
 ?column? 
----------
 f
(1 row)

SELECT 50::uint4 > -1::int4;
 ?column? 
----------
 t
(1 row)

SELECT 80::uint4 >= 70::int4;
 ?column? 
----------
 t
(1 row)

SELECT 70::uint4 >= 70::int4;
 ?column? 
----------
 t
(1 row)

SELECT 60::uint4 >= 70::int4;
 ?column? 
----------
 f
(1 row)

SELECT 50::uint4 >= -1::int4;
 ?column? 
----------
 t
(1 row)