\set ECHO all
-- Test round-trip equivalence of parsed and deparsed numbers
-- This file is auto-generated by deparse-generate.pl
CREATE TABLE test_deparse_numeric_1 (a numeric CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_1_a_check';
     pg_get_constraintdef      
-------------------------------
 CHECK ((a < ((-1))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_2 (a numeric CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_2_a_check';
    pg_get_constraintdef     
-----------------------------
 CHECK ((a < (-1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_3 (a numeric CHECK (a < -1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_3_a_check';
      pg_get_constraintdef      
--------------------------------
 CHECK ((a < (- (1)::numeric)))
(1 row)

CREATE TABLE test_deparse_numeric_4 (a numeric CHECK (a < (-1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_4_a_check';
     pg_get_constraintdef      
-------------------------------
 CHECK ((a < ((-1))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_5 (a numeric CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_5_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_6 (a numeric CHECK (a < '-1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_6_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_7 (a numeric CHECK (a < -1.1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_7_a_check';
 pg_get_constraintdef  
-----------------------
 CHECK ((a < (- 1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_8 (a numeric CHECK (a < (-1.1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_8_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_9 (a numeric CHECK (a < '-nan'));
ERROR:  invalid input syntax for type numeric: "-nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_9_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_10 (a numeric CHECK (a < '-inf'));
ERROR:  invalid input syntax for type numeric: "-inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_10_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_11 (a numeric CHECK (a < -null::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_11_a_check';
      pg_get_constraintdef       
---------------------------------
 CHECK ((a < (- NULL::numeric)))
(1 row)

CREATE TABLE test_deparse_numeric_12 (a numeric CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_12_a_check';
     pg_get_constraintdef      
-------------------------------
 CHECK ((a < ((-1))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_13 (a numeric CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_13_a_check';
    pg_get_constraintdef     
-----------------------------
 CHECK ((a < (-1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_14 (a numeric CHECK (a < -1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_14_a_check';
                    pg_get_constraintdef                     
-------------------------------------------------------------
 CHECK (((a)::double precision < (- (1)::double precision)))
(1 row)

CREATE TABLE test_deparse_numeric_15 (a numeric CHECK (a < (-1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_15_a_check';
                    pg_get_constraintdef                    
------------------------------------------------------------
 CHECK (((a)::double precision < ((-1))::double precision))
(1 row)

CREATE TABLE test_deparse_numeric_16 (a numeric CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_16_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_17 (a numeric CHECK (a < '-1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_17_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_18 (a numeric CHECK (a < -1.1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_18_a_check';
                     pg_get_constraintdef                      
---------------------------------------------------------------
 CHECK (((a)::double precision < (- (1.1)::double precision)))
(1 row)

CREATE TABLE test_deparse_numeric_19 (a numeric CHECK (a < (-1.1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_19_a_check';
                     pg_get_constraintdef                     
--------------------------------------------------------------
 CHECK (((a)::double precision < ((-1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_numeric_20 (a numeric CHECK (a < '-nan'));
ERROR:  invalid input syntax for type numeric: "-nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_20_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_21 (a numeric CHECK (a < '-inf'));
ERROR:  invalid input syntax for type numeric: "-inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_21_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_22 (a numeric CHECK (a < -null::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_22_a_check';
                     pg_get_constraintdef                     
--------------------------------------------------------------
 CHECK (((a)::double precision < (- NULL::double precision)))
(1 row)

CREATE TABLE test_deparse_numeric_23 (a numeric CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_23_a_check';
     pg_get_constraintdef      
-------------------------------
 CHECK ((a < ((-1))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_24 (a numeric CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_24_a_check';
    pg_get_constraintdef     
-----------------------------
 CHECK ((a < (-1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_25 (a numeric CHECK (a < -1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_25_a_check';
      pg_get_constraintdef      
--------------------------------
 CHECK ((a < ((- 1))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_26 (a numeric CHECK (a < (-1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_26_a_check';
     pg_get_constraintdef      
-------------------------------
 CHECK ((a < ((-1))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_27 (a numeric CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_27_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_28 (a numeric CHECK (a < '-1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_28_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1.1)))
(1 row)

CREATE TABLE test_deparse_numeric_29 (a numeric CHECK (a < -1.1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_29_a_check';
            pg_get_constraintdef             
---------------------------------------------
 CHECK ((a < ((- (1.1)::integer))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_30 (a numeric CHECK (a < (-1.1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_30_a_check';
            pg_get_constraintdef            
--------------------------------------------
 CHECK ((a < (((-1.1))::integer)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_31 (a numeric CHECK (a < '-nan'));
ERROR:  invalid input syntax for type numeric: "-nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_31_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_32 (a numeric CHECK (a < '-inf'));
ERROR:  invalid input syntax for type numeric: "-inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_32_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_33 (a numeric CHECK (a < -null::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_33_a_check';
            pg_get_constraintdef            
--------------------------------------------
 CHECK ((a < ((- NULL::integer))::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_34 (a numeric CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_34_a_check';
    pg_get_constraintdef    
----------------------------
 CHECK ((a < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_35 (a numeric CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_35_a_check';
   pg_get_constraintdef   
--------------------------
 CHECK ((a < 1::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_36 (a numeric CHECK (a < 1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_36_a_check';
    pg_get_constraintdef    
----------------------------
 CHECK ((a < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_37 (a numeric CHECK (a < (1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_37_a_check';
    pg_get_constraintdef    
----------------------------
 CHECK ((a < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_38 (a numeric CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_38_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_39 (a numeric CHECK (a < '1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_39_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_40 (a numeric CHECK (a < 1.1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_40_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_41 (a numeric CHECK (a < (1.1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_41_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_42 (a numeric CHECK (a < 'nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_42_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK ((a < 'NaN'::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_43 (a numeric CHECK (a < 'inf'));
ERROR:  invalid input syntax for type numeric: "inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_43_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_44 (a numeric CHECK (a < null::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_44_a_check';
    pg_get_constraintdef     
-----------------------------
 CHECK ((a < NULL::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_45 (a numeric CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_45_a_check';
    pg_get_constraintdef    
----------------------------
 CHECK ((a < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_46 (a numeric CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_46_a_check';
   pg_get_constraintdef   
--------------------------
 CHECK ((a < 1::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_47 (a numeric CHECK (a < 1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_47_a_check';
                  pg_get_constraintdef                   
---------------------------------------------------------
 CHECK (((a)::double precision < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_numeric_48 (a numeric CHECK (a < (1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_48_a_check';
                  pg_get_constraintdef                   
---------------------------------------------------------
 CHECK (((a)::double precision < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_numeric_49 (a numeric CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_49_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_50 (a numeric CHECK (a < '1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_50_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_51 (a numeric CHECK (a < 1.1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_51_a_check';
                   pg_get_constraintdef                    
-----------------------------------------------------------
 CHECK (((a)::double precision < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_numeric_52 (a numeric CHECK (a < (1.1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_52_a_check';
                   pg_get_constraintdef                    
-----------------------------------------------------------
 CHECK (((a)::double precision < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_numeric_53 (a numeric CHECK (a < 'nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_53_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK ((a < 'NaN'::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_54 (a numeric CHECK (a < 'inf'));
ERROR:  invalid input syntax for type numeric: "inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_54_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_55 (a numeric CHECK (a < null::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_55_a_check';
                   pg_get_constraintdef                   
----------------------------------------------------------
 CHECK (((a)::double precision < NULL::double precision))
(1 row)

CREATE TABLE test_deparse_numeric_56 (a numeric CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_56_a_check';
    pg_get_constraintdef    
----------------------------
 CHECK ((a < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_57 (a numeric CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_57_a_check';
   pg_get_constraintdef   
--------------------------
 CHECK ((a < 1::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_58 (a numeric CHECK (a < 1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_58_a_check';
    pg_get_constraintdef    
----------------------------
 CHECK ((a < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_59 (a numeric CHECK (a < (1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_59_a_check';
    pg_get_constraintdef    
----------------------------
 CHECK ((a < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_60 (a numeric CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_60_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_61 (a numeric CHECK (a < '1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_61_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1.1))
(1 row)

CREATE TABLE test_deparse_numeric_62 (a numeric CHECK (a < 1.1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_62_a_check';
          pg_get_constraintdef           
-----------------------------------------
 CHECK ((a < ((1.1)::integer)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_63 (a numeric CHECK (a < (1.1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_63_a_check';
          pg_get_constraintdef           
-----------------------------------------
 CHECK ((a < ((1.1)::integer)::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_64 (a numeric CHECK (a < 'nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_64_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK ((a < 'NaN'::numeric))
(1 row)

CREATE TABLE test_deparse_numeric_65 (a numeric CHECK (a < 'inf'));
ERROR:  invalid input syntax for type numeric: "inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_65_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_numeric_66 (a numeric CHECK (a < null::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_numeric_66_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < (NULL::integer)::numeric))
(1 row)

CREATE TABLE test_deparse_float8_1 (a float8 CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_1_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < ((-1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_2 (a float8 CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_2_a_check';
         pg_get_constraintdef         
--------------------------------------
 CHECK ((a < (-1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_3 (a float8 CHECK (a < -1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_3_a_check';
                pg_get_constraintdef                
----------------------------------------------------
 CHECK ((a < ((- (1)::numeric))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_4 (a float8 CHECK (a < (-1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_4_a_check';
               pg_get_constraintdef                
---------------------------------------------------
 CHECK ((a < (((-1))::numeric)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_5 (a float8 CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_5_a_check';
           pg_get_constraintdef           
------------------------------------------
 CHECK ((a < ((-1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_6 (a float8 CHECK (a < '-1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_6_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < (-1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_7 (a float8 CHECK (a < -1.1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_7_a_check';
           pg_get_constraintdef            
-------------------------------------------
 CHECK ((a < ((- 1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_8 (a float8 CHECK (a < (-1.1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_8_a_check';
           pg_get_constraintdef           
------------------------------------------
 CHECK ((a < ((-1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_9 (a float8 CHECK (a < '-nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_9_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < 'NaN'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_10 (a float8 CHECK (a < '-inf'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_10_a_check';
            pg_get_constraintdef             
---------------------------------------------
 CHECK ((a < '-Infinity'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_11 (a float8 CHECK (a < -null::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_11_a_check';
                pg_get_constraintdef                 
-----------------------------------------------------
 CHECK ((a < ((- NULL::numeric))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_12 (a float8 CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_12_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < ((-1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_13 (a float8 CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_13_a_check';
         pg_get_constraintdef         
--------------------------------------
 CHECK ((a < (-1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_14 (a float8 CHECK (a < -1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_14_a_check';
          pg_get_constraintdef           
-----------------------------------------
 CHECK ((a < (- (1)::double precision)))
(1 row)

CREATE TABLE test_deparse_float8_15 (a float8 CHECK (a < (-1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_15_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < ((-1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_16 (a float8 CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_16_a_check';
           pg_get_constraintdef           
------------------------------------------
 CHECK ((a < ((-1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_17 (a float8 CHECK (a < '-1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_17_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < (-1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_18 (a float8 CHECK (a < -1.1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_18_a_check';
           pg_get_constraintdef            
-------------------------------------------
 CHECK ((a < (- (1.1)::double precision)))
(1 row)

CREATE TABLE test_deparse_float8_19 (a float8 CHECK (a < (-1.1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_19_a_check';
           pg_get_constraintdef           
------------------------------------------
 CHECK ((a < ((-1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_20 (a float8 CHECK (a < '-nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_20_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < 'NaN'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_21 (a float8 CHECK (a < '-inf'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_21_a_check';
            pg_get_constraintdef             
---------------------------------------------
 CHECK ((a < '-Infinity'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_22 (a float8 CHECK (a < -null::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_22_a_check';
           pg_get_constraintdef           
------------------------------------------
 CHECK ((a < (- NULL::double precision)))
(1 row)

CREATE TABLE test_deparse_float8_23 (a float8 CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_23_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < ((-1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_24 (a float8 CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_24_a_check';
         pg_get_constraintdef         
--------------------------------------
 CHECK ((a < (-1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_25 (a float8 CHECK (a < -1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_25_a_check';
          pg_get_constraintdef           
-----------------------------------------
 CHECK ((a < ((- 1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_26 (a float8 CHECK (a < (-1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_26_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < ((-1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_27 (a float8 CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_27_a_check';
           pg_get_constraintdef           
------------------------------------------
 CHECK ((a < ((-1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_28 (a float8 CHECK (a < '-1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_28_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK ((a < (-1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_29 (a float8 CHECK (a < -1.1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_29_a_check';
                 pg_get_constraintdef                 
------------------------------------------------------
 CHECK ((a < ((- (1.1)::integer))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_30 (a float8 CHECK (a < (-1.1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_30_a_check';
                pg_get_constraintdef                 
-----------------------------------------------------
 CHECK ((a < (((-1.1))::integer)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_31 (a float8 CHECK (a < '-nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_31_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < 'NaN'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_32 (a float8 CHECK (a < '-inf'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_32_a_check';
            pg_get_constraintdef             
---------------------------------------------
 CHECK ((a < '-Infinity'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_33 (a float8 CHECK (a < -null::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_33_a_check';
                pg_get_constraintdef                 
-----------------------------------------------------
 CHECK ((a < ((- NULL::integer))::double precision))
(1 row)

CREATE TABLE test_deparse_float8_34 (a float8 CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_34_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_35 (a float8 CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_35_a_check';
       pg_get_constraintdef        
-----------------------------------
 CHECK ((a < 1::double precision))
(1 row)

CREATE TABLE test_deparse_float8_36 (a float8 CHECK (a < 1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_36_a_check';
              pg_get_constraintdef              
------------------------------------------------
 CHECK ((a < ((1)::numeric)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_37 (a float8 CHECK (a < (1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_37_a_check';
              pg_get_constraintdef              
------------------------------------------------
 CHECK ((a < ((1)::numeric)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_38 (a float8 CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_38_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_39 (a float8 CHECK (a < '1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_39_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < 1.1::double precision))
(1 row)

CREATE TABLE test_deparse_float8_40 (a float8 CHECK (a < 1.1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_40_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_41 (a float8 CHECK (a < (1.1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_41_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_42 (a float8 CHECK (a < 'nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_42_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < 'NaN'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_43 (a float8 CHECK (a < 'inf'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_43_a_check';
            pg_get_constraintdef            
--------------------------------------------
 CHECK ((a < 'Infinity'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_44 (a float8 CHECK (a < null::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_44_a_check';
              pg_get_constraintdef               
-------------------------------------------------
 CHECK ((a < (NULL::numeric)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_45 (a float8 CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_45_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_46 (a float8 CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_46_a_check';
       pg_get_constraintdef        
-----------------------------------
 CHECK ((a < 1::double precision))
(1 row)

CREATE TABLE test_deparse_float8_47 (a float8 CHECK (a < 1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_47_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_48 (a float8 CHECK (a < (1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_48_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_49 (a float8 CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_49_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_50 (a float8 CHECK (a < '1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_50_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < 1.1::double precision))
(1 row)

CREATE TABLE test_deparse_float8_51 (a float8 CHECK (a < 1.1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_51_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_52 (a float8 CHECK (a < (1.1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_52_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_53 (a float8 CHECK (a < 'nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_53_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < 'NaN'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_54 (a float8 CHECK (a < 'inf'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_54_a_check';
            pg_get_constraintdef            
--------------------------------------------
 CHECK ((a < 'Infinity'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_55 (a float8 CHECK (a < null::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_55_a_check';
         pg_get_constraintdef         
--------------------------------------
 CHECK ((a < NULL::double precision))
(1 row)

CREATE TABLE test_deparse_float8_56 (a float8 CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_56_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_57 (a float8 CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_57_a_check';
       pg_get_constraintdef        
-----------------------------------
 CHECK ((a < 1::double precision))
(1 row)

CREATE TABLE test_deparse_float8_58 (a float8 CHECK (a < 1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_58_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_59 (a float8 CHECK (a < (1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_59_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_60 (a float8 CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_60_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_61 (a float8 CHECK (a < '1.1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_61_a_check';
        pg_get_constraintdef         
-------------------------------------
 CHECK ((a < 1.1::double precision))
(1 row)

CREATE TABLE test_deparse_float8_62 (a float8 CHECK (a < 1.1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_62_a_check';
               pg_get_constraintdef               
--------------------------------------------------
 CHECK ((a < ((1.1)::integer)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_63 (a float8 CHECK (a < (1.1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_63_a_check';
               pg_get_constraintdef               
--------------------------------------------------
 CHECK ((a < ((1.1)::integer)::double precision))
(1 row)

CREATE TABLE test_deparse_float8_64 (a float8 CHECK (a < 'nan'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_64_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK ((a < 'NaN'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_65 (a float8 CHECK (a < 'inf'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_65_a_check';
            pg_get_constraintdef            
--------------------------------------------
 CHECK ((a < 'Infinity'::double precision))
(1 row)

CREATE TABLE test_deparse_float8_66 (a float8 CHECK (a < null::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_float8_66_a_check';
              pg_get_constraintdef               
-------------------------------------------------
 CHECK ((a < (NULL::integer)::double precision))
(1 row)

CREATE TABLE test_deparse_int_1 (a int CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_1_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1)))
(1 row)

CREATE TABLE test_deparse_int_2 (a int CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_2_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1)))
(1 row)

CREATE TABLE test_deparse_int_3 (a int CHECK (a < -1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_3_a_check';
           pg_get_constraintdef            
-------------------------------------------
 CHECK (((a)::numeric < (- (1)::numeric)))
(1 row)

CREATE TABLE test_deparse_int_4 (a int CHECK (a < (-1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_4_a_check';
           pg_get_constraintdef           
------------------------------------------
 CHECK (((a)::numeric < ((-1))::numeric))
(1 row)

CREATE TABLE test_deparse_int_5 (a int CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_5_a_check';
      pg_get_constraintdef       
---------------------------------
 CHECK (((a)::numeric < (-1.1)))
(1 row)

CREATE TABLE test_deparse_int_6 (a int CHECK (a < '-1.1'));
ERROR:  invalid input syntax for integer: "-1.1"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_6_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_7 (a int CHECK (a < -1.1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_7_a_check';
       pg_get_constraintdef       
----------------------------------
 CHECK (((a)::numeric < (- 1.1)))
(1 row)

CREATE TABLE test_deparse_int_8 (a int CHECK (a < (-1.1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_8_a_check';
      pg_get_constraintdef       
---------------------------------
 CHECK (((a)::numeric < (-1.1)))
(1 row)

CREATE TABLE test_deparse_int_9 (a int CHECK (a < '-nan'));
ERROR:  invalid input syntax for integer: "-nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_9_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_10 (a int CHECK (a < '-inf'));
ERROR:  invalid input syntax for integer: "-inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_10_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_11 (a int CHECK (a < -null::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_11_a_check';
            pg_get_constraintdef            
--------------------------------------------
 CHECK (((a)::numeric < (- NULL::numeric)))
(1 row)

CREATE TABLE test_deparse_int_12 (a int CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_12_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1)))
(1 row)

CREATE TABLE test_deparse_int_13 (a int CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_13_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1)))
(1 row)

CREATE TABLE test_deparse_int_14 (a int CHECK (a < -1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_14_a_check';
                    pg_get_constraintdef                     
-------------------------------------------------------------
 CHECK (((a)::double precision < (- (1)::double precision)))
(1 row)

CREATE TABLE test_deparse_int_15 (a int CHECK (a < (-1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_15_a_check';
                    pg_get_constraintdef                    
------------------------------------------------------------
 CHECK (((a)::double precision < ((-1))::double precision))
(1 row)

CREATE TABLE test_deparse_int_16 (a int CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_16_a_check';
      pg_get_constraintdef       
---------------------------------
 CHECK (((a)::numeric < (-1.1)))
(1 row)

CREATE TABLE test_deparse_int_17 (a int CHECK (a < '-1.1'));
ERROR:  invalid input syntax for integer: "-1.1"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_17_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_18 (a int CHECK (a < -1.1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_18_a_check';
                     pg_get_constraintdef                      
---------------------------------------------------------------
 CHECK (((a)::double precision < (- (1.1)::double precision)))
(1 row)

CREATE TABLE test_deparse_int_19 (a int CHECK (a < (-1.1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_19_a_check';
                     pg_get_constraintdef                     
--------------------------------------------------------------
 CHECK (((a)::double precision < ((-1.1))::double precision))
(1 row)

CREATE TABLE test_deparse_int_20 (a int CHECK (a < '-nan'));
ERROR:  invalid input syntax for integer: "-nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_20_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_21 (a int CHECK (a < '-inf'));
ERROR:  invalid input syntax for integer: "-inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_21_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_22 (a int CHECK (a < -null::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_22_a_check';
                     pg_get_constraintdef                     
--------------------------------------------------------------
 CHECK (((a)::double precision < (- NULL::double precision)))
(1 row)

CREATE TABLE test_deparse_int_23 (a int CHECK (a < -1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_23_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1)))
(1 row)

CREATE TABLE test_deparse_int_24 (a int CHECK (a < '-1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_24_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1)))
(1 row)

CREATE TABLE test_deparse_int_25 (a int CHECK (a < -1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_25_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (- 1)))
(1 row)

CREATE TABLE test_deparse_int_26 (a int CHECK (a < (-1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_26_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < (-1)))
(1 row)

CREATE TABLE test_deparse_int_27 (a int CHECK (a < -1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_27_a_check';
      pg_get_constraintdef       
---------------------------------
 CHECK (((a)::numeric < (-1.1)))
(1 row)

CREATE TABLE test_deparse_int_28 (a int CHECK (a < '-1.1'));
ERROR:  invalid input syntax for integer: "-1.1"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_28_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_29 (a int CHECK (a < -1.1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_29_a_check';
       pg_get_constraintdef       
----------------------------------
 CHECK ((a < (- (1.1)::integer)))
(1 row)

CREATE TABLE test_deparse_int_30 (a int CHECK (a < (-1.1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_30_a_check';
      pg_get_constraintdef       
---------------------------------
 CHECK ((a < ((-1.1))::integer))
(1 row)

CREATE TABLE test_deparse_int_31 (a int CHECK (a < '-nan'));
ERROR:  invalid input syntax for integer: "-nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_31_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_32 (a int CHECK (a < '-inf'));
ERROR:  invalid input syntax for integer: "-inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_32_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_33 (a int CHECK (a < -null::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_33_a_check';
      pg_get_constraintdef       
---------------------------------
 CHECK ((a < (- NULL::integer)))
(1 row)

CREATE TABLE test_deparse_int_34 (a int CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_34_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_35 (a int CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_35_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_36 (a int CHECK (a < 1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_36_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK (((a)::numeric < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_int_37 (a int CHECK (a < (1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_37_a_check';
         pg_get_constraintdef          
---------------------------------------
 CHECK (((a)::numeric < (1)::numeric))
(1 row)

CREATE TABLE test_deparse_int_38 (a int CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_38_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK (((a)::numeric < 1.1))
(1 row)

CREATE TABLE test_deparse_int_39 (a int CHECK (a < '1.1'));
ERROR:  invalid input syntax for integer: "1.1"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_39_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_40 (a int CHECK (a < 1.1::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_40_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK (((a)::numeric < 1.1))
(1 row)

CREATE TABLE test_deparse_int_41 (a int CHECK (a < (1.1)::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_41_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK (((a)::numeric < 1.1))
(1 row)

CREATE TABLE test_deparse_int_42 (a int CHECK (a < 'nan'));
ERROR:  invalid input syntax for integer: "nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_42_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_43 (a int CHECK (a < 'inf'));
ERROR:  invalid input syntax for integer: "inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_43_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_44 (a int CHECK (a < null::numeric));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_44_a_check';
          pg_get_constraintdef          
----------------------------------------
 CHECK (((a)::numeric < NULL::numeric))
(1 row)

CREATE TABLE test_deparse_int_45 (a int CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_45_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_46 (a int CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_46_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_47 (a int CHECK (a < 1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_47_a_check';
                  pg_get_constraintdef                   
---------------------------------------------------------
 CHECK (((a)::double precision < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_int_48 (a int CHECK (a < (1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_48_a_check';
                  pg_get_constraintdef                   
---------------------------------------------------------
 CHECK (((a)::double precision < (1)::double precision))
(1 row)

CREATE TABLE test_deparse_int_49 (a int CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_49_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK (((a)::numeric < 1.1))
(1 row)

CREATE TABLE test_deparse_int_50 (a int CHECK (a < '1.1'));
ERROR:  invalid input syntax for integer: "1.1"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_50_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_51 (a int CHECK (a < 1.1::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_51_a_check';
                   pg_get_constraintdef                    
-----------------------------------------------------------
 CHECK (((a)::double precision < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_int_52 (a int CHECK (a < (1.1)::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_52_a_check';
                   pg_get_constraintdef                    
-----------------------------------------------------------
 CHECK (((a)::double precision < (1.1)::double precision))
(1 row)

CREATE TABLE test_deparse_int_53 (a int CHECK (a < 'nan'));
ERROR:  invalid input syntax for integer: "nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_53_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_54 (a int CHECK (a < 'inf'));
ERROR:  invalid input syntax for integer: "inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_54_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_55 (a int CHECK (a < null::float8));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_55_a_check';
                   pg_get_constraintdef                   
----------------------------------------------------------
 CHECK (((a)::double precision < NULL::double precision))
(1 row)

CREATE TABLE test_deparse_int_56 (a int CHECK (a < 1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_56_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_57 (a int CHECK (a < '1'));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_57_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_58 (a int CHECK (a < 1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_58_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_59 (a int CHECK (a < (1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_59_a_check';
 pg_get_constraintdef 
----------------------
 CHECK ((a < 1))
(1 row)

CREATE TABLE test_deparse_int_60 (a int CHECK (a < 1.1));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_60_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK (((a)::numeric < 1.1))
(1 row)

CREATE TABLE test_deparse_int_61 (a int CHECK (a < '1.1'));
ERROR:  invalid input syntax for integer: "1.1"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_61_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_62 (a int CHECK (a < 1.1::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_62_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK ((a < (1.1)::integer))
(1 row)

CREATE TABLE test_deparse_int_63 (a int CHECK (a < (1.1)::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_63_a_check';
     pg_get_constraintdef     
------------------------------
 CHECK ((a < (1.1)::integer))
(1 row)

CREATE TABLE test_deparse_int_64 (a int CHECK (a < 'nan'));
ERROR:  invalid input syntax for integer: "nan"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_64_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_65 (a int CHECK (a < 'inf'));
ERROR:  invalid input syntax for integer: "inf"
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_65_a_check';
 pg_get_constraintdef 
----------------------
(0 rows)

CREATE TABLE test_deparse_int_66 (a int CHECK (a < null::int));
SELECT pg_get_constraintdef(pc.oid) FROM pg_constraint pc WHERE conname = 'test_deparse_int_66_a_check';
    pg_get_constraintdef     
-----------------------------
 CHECK ((a < NULL::integer))
(1 row)

-- End of test