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