\set ECHO none ok 1..0 1..174 ok 1 - No NULL variants ok 2 - Verify result of cast '{-1,-1,1}'::integer[] ok 3 - Verify result of cast '{-1,0,1}'::integer[] ok 4 - Verify result of cast '{-1,1,1}'::integer[] ok 5 - Verify result of cast '{NULL,-1,1}'::integer[] ok 6 - Verify result of cast '{NULL,0,1}'::integer[] ok 7 - Verify result of cast '{NULL,1,1}'::integer[] ok 8 - Verify result of cast '{-1,NULL,1}'::integer[] ok 9 - Verify result of cast NULL::integer[] ok 10 - SET base_variant_b ok 11 - Verify text_in(text_out()) works for (integer[],"{-1,-1,1}") ok 12 - Verify text_in(text_out()) works for (integer[],"{-1,0,1}") ok 13 - Verify text_in(text_out()) works for (integer[],"{-1,1,1}") ok 14 - Verify text_in(text_out()) works for (integer[],"{NULL,-1,1}") ok 15 - Verify text_in(text_out()) works for (integer[],"{NULL,0,1}") ok 16 - Verify text_in(text_out()) works for (integer[],"{NULL,1,1}") ok 17 - Verify text_in(text_out()) works for (integer[],"{-1,NULL,1}") ok 18 - Verify text_in(text_out()) works for (integer[],) ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 - No NULL variants ok 28 - Verify result of cast '{-1,0,1}'::integer[] ok 29 - SET compare_variant_b ok 30 - Verify text_in(text_out()) works for (integer[],"{-1,0,1}") ok 31 - check casted vs uncasted for '{-1,0,1}'::integer[] < '{-1,-1,1}'::integer[] ok 32 - check casted vs uncasted for '{-1,0,1}'::integer[] < '{-1,0,1}'::integer[] ok 33 - check casted vs uncasted for '{-1,0,1}'::integer[] < '{-1,1,1}'::integer[] ok 34 - check casted vs uncasted for '{-1,0,1}'::integer[] < '{-1,NULL,1}'::integer[] ok 35 - check casted vs uncasted for '{-1,0,1}'::integer[] < '{NULL,-1,1}'::integer[] ok 36 - check casted vs uncasted for '{-1,0,1}'::integer[] < '{NULL,0,1}'::integer[] ok 37 - check casted vs uncasted for '{-1,0,1}'::integer[] < '{NULL,1,1}'::integer[] ok 38 - check casted vs uncasted for '{-1,0,1}'::integer[] < NULL::integer[] ok 39 - check casted vs uncasted for '{-1,0,1}'::integer[] <= '{-1,-1,1}'::integer[] ok 40 - check casted vs uncasted for '{-1,0,1}'::integer[] <= '{-1,0,1}'::integer[] ok 41 - check casted vs uncasted for '{-1,0,1}'::integer[] <= '{-1,1,1}'::integer[] ok 42 - check casted vs uncasted for '{-1,0,1}'::integer[] <= '{-1,NULL,1}'::integer[] ok 43 - check casted vs uncasted for '{-1,0,1}'::integer[] <= '{NULL,-1,1}'::integer[] ok 44 - check casted vs uncasted for '{-1,0,1}'::integer[] <= '{NULL,0,1}'::integer[] ok 45 - check casted vs uncasted for '{-1,0,1}'::integer[] <= '{NULL,1,1}'::integer[] ok 46 - check casted vs uncasted for '{-1,0,1}'::integer[] <= NULL::integer[] ok 47 - check casted vs uncasted for '{-1,0,1}'::integer[] = '{-1,-1,1}'::integer[] ok 48 - check casted vs uncasted for '{-1,0,1}'::integer[] = '{-1,0,1}'::integer[] ok 49 - check casted vs uncasted for '{-1,0,1}'::integer[] = '{-1,1,1}'::integer[] ok 50 - check casted vs uncasted for '{-1,0,1}'::integer[] = '{-1,NULL,1}'::integer[] ok 51 - check casted vs uncasted for '{-1,0,1}'::integer[] = '{NULL,-1,1}'::integer[] ok 52 - check casted vs uncasted for '{-1,0,1}'::integer[] = '{NULL,0,1}'::integer[] ok 53 - check casted vs uncasted for '{-1,0,1}'::integer[] = '{NULL,1,1}'::integer[] ok 54 - check casted vs uncasted for '{-1,0,1}'::integer[] = NULL::integer[] ok 55 - check casted vs uncasted for '{-1,0,1}'::integer[] >= '{-1,-1,1}'::integer[] ok 56 - check casted vs uncasted for '{-1,0,1}'::integer[] >= '{-1,0,1}'::integer[] ok 57 - check casted vs uncasted for '{-1,0,1}'::integer[] >= '{-1,1,1}'::integer[] ok 58 - check casted vs uncasted for '{-1,0,1}'::integer[] >= '{-1,NULL,1}'::integer[] ok 59 - check casted vs uncasted for '{-1,0,1}'::integer[] >= '{NULL,-1,1}'::integer[] ok 60 - check casted vs uncasted for '{-1,0,1}'::integer[] >= '{NULL,0,1}'::integer[] ok 61 - check casted vs uncasted for '{-1,0,1}'::integer[] >= '{NULL,1,1}'::integer[] ok 62 - check casted vs uncasted for '{-1,0,1}'::integer[] >= NULL::integer[] ok 63 - check casted vs uncasted for '{-1,0,1}'::integer[] > '{-1,-1,1}'::integer[] ok 64 - check casted vs uncasted for '{-1,0,1}'::integer[] > '{-1,0,1}'::integer[] ok 65 - check casted vs uncasted for '{-1,0,1}'::integer[] > '{-1,1,1}'::integer[] ok 66 - check casted vs uncasted for '{-1,0,1}'::integer[] > '{-1,NULL,1}'::integer[] ok 67 - check casted vs uncasted for '{-1,0,1}'::integer[] > '{NULL,-1,1}'::integer[] ok 68 - check casted vs uncasted for '{-1,0,1}'::integer[] > '{NULL,0,1}'::integer[] ok 69 - check casted vs uncasted for '{-1,0,1}'::integer[] > '{NULL,1,1}'::integer[] ok 70 - check casted vs uncasted for '{-1,0,1}'::integer[] > NULL::integer[] ok 71 - check casted vs uncasted for '{-1,0,1}'::integer[] != '{-1,-1,1}'::integer[] ok 72 - check casted vs uncasted for '{-1,0,1}'::integer[] != '{-1,0,1}'::integer[] ok 73 - check casted vs uncasted for '{-1,0,1}'::integer[] != '{-1,1,1}'::integer[] ok 74 - check casted vs uncasted for '{-1,0,1}'::integer[] != '{-1,NULL,1}'::integer[] ok 75 - check casted vs uncasted for '{-1,0,1}'::integer[] != '{NULL,-1,1}'::integer[] ok 76 - check casted vs uncasted for '{-1,0,1}'::integer[] != '{NULL,0,1}'::integer[] ok 77 - check casted vs uncasted for '{-1,0,1}'::integer[] != '{NULL,1,1}'::integer[] ok 78 - check casted vs uncasted for '{-1,0,1}'::integer[] != NULL::integer[] ok 79 - check variant vs uncasted for '{-1,0,1}'::integer[] < '{-1,-1,1}'::integer[] ok 80 - check variant vs uncasted for '{-1,0,1}'::integer[] < '{-1,0,1}'::integer[] ok 81 - check variant vs uncasted for '{-1,0,1}'::integer[] < '{-1,1,1}'::integer[] ok 82 - check variant vs uncasted for '{-1,0,1}'::integer[] < '{-1,NULL,1}'::integer[] ok 83 - check variant vs uncasted for '{-1,0,1}'::integer[] < '{NULL,-1,1}'::integer[] ok 84 - check variant vs uncasted for '{-1,0,1}'::integer[] < '{NULL,0,1}'::integer[] ok 85 - check variant vs uncasted for '{-1,0,1}'::integer[] < '{NULL,1,1}'::integer[] ok 86 - check variant vs uncasted for '{-1,0,1}'::integer[] < NULL::integer[] ok 87 - check variant vs uncasted for '{-1,0,1}'::integer[] <= '{-1,-1,1}'::integer[] ok 88 - check variant vs uncasted for '{-1,0,1}'::integer[] <= '{-1,0,1}'::integer[] ok 89 - check variant vs uncasted for '{-1,0,1}'::integer[] <= '{-1,1,1}'::integer[] ok 90 - check variant vs uncasted for '{-1,0,1}'::integer[] <= '{-1,NULL,1}'::integer[] ok 91 - check variant vs uncasted for '{-1,0,1}'::integer[] <= '{NULL,-1,1}'::integer[] ok 92 - check variant vs uncasted for '{-1,0,1}'::integer[] <= '{NULL,0,1}'::integer[] ok 93 - check variant vs uncasted for '{-1,0,1}'::integer[] <= '{NULL,1,1}'::integer[] ok 94 - check variant vs uncasted for '{-1,0,1}'::integer[] <= NULL::integer[] ok 95 - check variant vs uncasted for '{-1,0,1}'::integer[] = '{-1,-1,1}'::integer[] ok 96 - check variant vs uncasted for '{-1,0,1}'::integer[] = '{-1,0,1}'::integer[] ok 97 - check variant vs uncasted for '{-1,0,1}'::integer[] = '{-1,1,1}'::integer[] ok 98 - check variant vs uncasted for '{-1,0,1}'::integer[] = '{-1,NULL,1}'::integer[] ok 99 - check variant vs uncasted for '{-1,0,1}'::integer[] = '{NULL,-1,1}'::integer[] ok 100 - check variant vs uncasted for '{-1,0,1}'::integer[] = '{NULL,0,1}'::integer[] ok 101 - check variant vs uncasted for '{-1,0,1}'::integer[] = '{NULL,1,1}'::integer[] ok 102 - check variant vs uncasted for '{-1,0,1}'::integer[] = NULL::integer[] ok 103 - check variant vs uncasted for '{-1,0,1}'::integer[] >= '{-1,-1,1}'::integer[] ok 104 - check variant vs uncasted for '{-1,0,1}'::integer[] >= '{-1,0,1}'::integer[] ok 105 - check variant vs uncasted for '{-1,0,1}'::integer[] >= '{-1,1,1}'::integer[] ok 106 - check variant vs uncasted for '{-1,0,1}'::integer[] >= '{-1,NULL,1}'::integer[] ok 107 - check variant vs uncasted for '{-1,0,1}'::integer[] >= '{NULL,-1,1}'::integer[] ok 108 - check variant vs uncasted for '{-1,0,1}'::integer[] >= '{NULL,0,1}'::integer[] ok 109 - check variant vs uncasted for '{-1,0,1}'::integer[] >= '{NULL,1,1}'::integer[] ok 110 - check variant vs uncasted for '{-1,0,1}'::integer[] >= NULL::integer[] ok 111 - check variant vs uncasted for '{-1,0,1}'::integer[] > '{-1,-1,1}'::integer[] ok 112 - check variant vs uncasted for '{-1,0,1}'::integer[] > '{-1,0,1}'::integer[] ok 113 - check variant vs uncasted for '{-1,0,1}'::integer[] > '{-1,1,1}'::integer[] ok 114 - check variant vs uncasted for '{-1,0,1}'::integer[] > '{-1,NULL,1}'::integer[] ok 115 - check variant vs uncasted for '{-1,0,1}'::integer[] > '{NULL,-1,1}'::integer[] ok 116 - check variant vs uncasted for '{-1,0,1}'::integer[] > '{NULL,0,1}'::integer[] ok 117 - check variant vs uncasted for '{-1,0,1}'::integer[] > '{NULL,1,1}'::integer[] ok 118 - check variant vs uncasted for '{-1,0,1}'::integer[] > NULL::integer[] ok 119 - check variant vs uncasted for '{-1,0,1}'::integer[] != '{-1,-1,1}'::integer[] ok 120 - check variant vs uncasted for '{-1,0,1}'::integer[] != '{-1,0,1}'::integer[] ok 121 - check variant vs uncasted for '{-1,0,1}'::integer[] != '{-1,1,1}'::integer[] ok 122 - check variant vs uncasted for '{-1,0,1}'::integer[] != '{-1,NULL,1}'::integer[] ok 123 - check variant vs uncasted for '{-1,0,1}'::integer[] != '{NULL,-1,1}'::integer[] ok 124 - check variant vs uncasted for '{-1,0,1}'::integer[] != '{NULL,0,1}'::integer[] ok 125 - check variant vs uncasted for '{-1,0,1}'::integer[] != '{NULL,1,1}'::integer[] ok 126 - check variant vs uncasted for '{-1,0,1}'::integer[] != NULL::integer[] ok 127 - check variant vs casted for '''{-1,0,1}''::integer[]' < '''{-1,-1,1}''::integer[]' ok 128 - check variant vs casted for '''{-1,0,1}''::integer[]' < '''{-1,0,1}''::integer[]' ok 129 - check variant vs casted for '''{-1,0,1}''::integer[]' < '''{-1,1,1}''::integer[]' ok 130 - check variant vs casted for '''{-1,0,1}''::integer[]' < '''{-1,NULL,1}''::integer[]' ok 131 - check variant vs casted for '''{-1,0,1}''::integer[]' < '''{NULL,-1,1}''::integer[]' ok 132 - check variant vs casted for '''{-1,0,1}''::integer[]' < '''{NULL,0,1}''::integer[]' ok 133 - check variant vs casted for '''{-1,0,1}''::integer[]' < '''{NULL,1,1}''::integer[]' ok 134 - check variant vs casted for '''{-1,0,1}''::integer[]' < 'NULL::integer[]' ok 135 - check variant vs casted for '''{-1,0,1}''::integer[]' <= '''{-1,-1,1}''::integer[]' ok 136 - check variant vs casted for '''{-1,0,1}''::integer[]' <= '''{-1,0,1}''::integer[]' ok 137 - check variant vs casted for '''{-1,0,1}''::integer[]' <= '''{-1,1,1}''::integer[]' ok 138 - check variant vs casted for '''{-1,0,1}''::integer[]' <= '''{-1,NULL,1}''::integer[]' ok 139 - check variant vs casted for '''{-1,0,1}''::integer[]' <= '''{NULL,-1,1}''::integer[]' ok 140 - check variant vs casted for '''{-1,0,1}''::integer[]' <= '''{NULL,0,1}''::integer[]' ok 141 - check variant vs casted for '''{-1,0,1}''::integer[]' <= '''{NULL,1,1}''::integer[]' ok 142 - check variant vs casted for '''{-1,0,1}''::integer[]' <= 'NULL::integer[]' ok 143 - check variant vs casted for '''{-1,0,1}''::integer[]' = '''{-1,-1,1}''::integer[]' ok 144 - check variant vs casted for '''{-1,0,1}''::integer[]' = '''{-1,0,1}''::integer[]' ok 145 - check variant vs casted for '''{-1,0,1}''::integer[]' = '''{-1,1,1}''::integer[]' ok 146 - check variant vs casted for '''{-1,0,1}''::integer[]' = '''{-1,NULL,1}''::integer[]' ok 147 - check variant vs casted for '''{-1,0,1}''::integer[]' = '''{NULL,-1,1}''::integer[]' ok 148 - check variant vs casted for '''{-1,0,1}''::integer[]' = '''{NULL,0,1}''::integer[]' ok 149 - check variant vs casted for '''{-1,0,1}''::integer[]' = '''{NULL,1,1}''::integer[]' ok 150 - check variant vs casted for '''{-1,0,1}''::integer[]' = 'NULL::integer[]' ok 151 - check variant vs casted for '''{-1,0,1}''::integer[]' >= '''{-1,-1,1}''::integer[]' ok 152 - check variant vs casted for '''{-1,0,1}''::integer[]' >= '''{-1,0,1}''::integer[]' ok 153 - check variant vs casted for '''{-1,0,1}''::integer[]' >= '''{-1,1,1}''::integer[]' ok 154 - check variant vs casted for '''{-1,0,1}''::integer[]' >= '''{-1,NULL,1}''::integer[]' ok 155 - check variant vs casted for '''{-1,0,1}''::integer[]' >= '''{NULL,-1,1}''::integer[]' ok 156 - check variant vs casted for '''{-1,0,1}''::integer[]' >= '''{NULL,0,1}''::integer[]' ok 157 - check variant vs casted for '''{-1,0,1}''::integer[]' >= '''{NULL,1,1}''::integer[]' ok 158 - check variant vs casted for '''{-1,0,1}''::integer[]' >= 'NULL::integer[]' ok 159 - check variant vs casted for '''{-1,0,1}''::integer[]' > '''{-1,-1,1}''::integer[]' ok 160 - check variant vs casted for '''{-1,0,1}''::integer[]' > '''{-1,0,1}''::integer[]' ok 161 - check variant vs casted for '''{-1,0,1}''::integer[]' > '''{-1,1,1}''::integer[]' ok 162 - check variant vs casted for '''{-1,0,1}''::integer[]' > '''{-1,NULL,1}''::integer[]' ok 163 - check variant vs casted for '''{-1,0,1}''::integer[]' > '''{NULL,-1,1}''::integer[]' ok 164 - check variant vs casted for '''{-1,0,1}''::integer[]' > '''{NULL,0,1}''::integer[]' ok 165 - check variant vs casted for '''{-1,0,1}''::integer[]' > '''{NULL,1,1}''::integer[]' ok 166 - check variant vs casted for '''{-1,0,1}''::integer[]' > 'NULL::integer[]' ok 167 - check variant vs casted for '''{-1,0,1}''::integer[]' != '''{-1,-1,1}''::integer[]' ok 168 - check variant vs casted for '''{-1,0,1}''::integer[]' != '''{-1,0,1}''::integer[]' ok 169 - check variant vs casted for '''{-1,0,1}''::integer[]' != '''{-1,1,1}''::integer[]' ok 170 - check variant vs casted for '''{-1,0,1}''::integer[]' != '''{-1,NULL,1}''::integer[]' ok 171 - check variant vs casted for '''{-1,0,1}''::integer[]' != '''{NULL,-1,1}''::integer[]' ok 172 - check variant vs casted for '''{-1,0,1}''::integer[]' != '''{NULL,0,1}''::integer[]' ok 173 - check variant vs casted for '''{-1,0,1}''::integer[]' != '''{NULL,1,1}''::integer[]' ok 174 - check variant vs casted for '''{-1,0,1}''::integer[]' != 'NULL::integer[]'