# Copyright Materialize, Inc. and contributors. All rights reserved. # # Use of this software is governed by the Business Source License # included in the LICENSE file at the root of this repository. # # As of the Change Date specified in that file, in accordance with # the Business Source License, use of this software will be governed # by the Apache License, Version 2.0. # # Make sure that all combinations of CHAR/VARCHAR values and comparison # operations have been exercised. This file was generated using the following # quick and dirty script: # # strings = ['a', 'a ', 'aaaaa', 'aaaaa ', 'aaaaaa', '', ' '] # types = ['char(3)','char(30)', 'varchar(3)','varchar(30)', 'text'] # operations = ['=', '>', '<'] # # for type1 in types: # for type2 in types: # for string1 in strings: # for string2 in strings: # for operation in operations: # print(f"query T\nSELECT '{string1}'::{type1} {operation} '{string2}'::{type2};\n----\nfoo\n") # query T SELECT 'a'::char(3) = 'a'::char(3); ---- true query T SELECT 'a'::char(3) > 'a'::char(3); ---- false query T SELECT 'a'::char(3) < 'a'::char(3); ---- false query T SELECT 'a'::char(3) = 'a '::char(3); ---- true query T SELECT 'a'::char(3) > 'a '::char(3); ---- false query T SELECT 'a'::char(3) < 'a '::char(3); ---- false query T SELECT 'a'::char(3) = 'aaaaa'::char(3); ---- false query T SELECT 'a'::char(3) > 'aaaaa'::char(3); ---- false query T SELECT 'a'::char(3) < 'aaaaa'::char(3); ---- true query T SELECT 'a'::char(3) = 'aaaaa '::char(3); ---- false query T SELECT 'a'::char(3) > 'aaaaa '::char(3); ---- false query T SELECT 'a'::char(3) < 'aaaaa '::char(3); ---- true query T SELECT 'a'::char(3) = 'aaaaaa'::char(3); ---- false query T SELECT 'a'::char(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'a'::char(3) < 'aaaaaa'::char(3); ---- true query T SELECT 'a'::char(3) = ''::char(3); ---- false query T SELECT 'a'::char(3) > ''::char(3); ---- true query T SELECT 'a'::char(3) < ''::char(3); ---- false query T SELECT 'a'::char(3) = ' '::char(3); ---- false query T SELECT 'a'::char(3) > ' '::char(3); ---- true query T SELECT 'a'::char(3) < ' '::char(3); ---- false query T SELECT 'a '::char(3) = 'a'::char(3); ---- true query T SELECT 'a '::char(3) > 'a'::char(3); ---- false query T SELECT 'a '::char(3) < 'a'::char(3); ---- false query T SELECT 'a '::char(3) = 'a '::char(3); ---- true query T SELECT 'a '::char(3) > 'a '::char(3); ---- false query T SELECT 'a '::char(3) < 'a '::char(3); ---- false query T SELECT 'a '::char(3) = 'aaaaa'::char(3); ---- false query T SELECT 'a '::char(3) > 'aaaaa'::char(3); ---- false query T SELECT 'a '::char(3) < 'aaaaa'::char(3); ---- true query T SELECT 'a '::char(3) = 'aaaaa '::char(3); ---- false query T SELECT 'a '::char(3) > 'aaaaa '::char(3); ---- false query T SELECT 'a '::char(3) < 'aaaaa '::char(3); ---- true query T SELECT 'a '::char(3) = 'aaaaaa'::char(3); ---- false query T SELECT 'a '::char(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'a '::char(3) < 'aaaaaa'::char(3); ---- true query T SELECT 'a '::char(3) = ''::char(3); ---- false query T SELECT 'a '::char(3) > ''::char(3); ---- true query T SELECT 'a '::char(3) < ''::char(3); ---- false query T SELECT 'a '::char(3) = ' '::char(3); ---- false query T SELECT 'a '::char(3) > ' '::char(3); ---- true query T SELECT 'a '::char(3) < ' '::char(3); ---- false query T SELECT 'aaaaa'::char(3) = 'a'::char(3); ---- false query T SELECT 'aaaaa'::char(3) > 'a'::char(3); ---- true query T SELECT 'aaaaa'::char(3) < 'a'::char(3); ---- false query T SELECT 'aaaaa'::char(3) = 'a '::char(3); ---- false query T SELECT 'aaaaa'::char(3) > 'a '::char(3); ---- true query T SELECT 'aaaaa'::char(3) < 'a '::char(3); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa'::char(3) > 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa'::char(3) > 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa'::char(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(3) = ''::char(3); ---- false query T SELECT 'aaaaa'::char(3) > ''::char(3); ---- true query T SELECT 'aaaaa'::char(3) < ''::char(3); ---- false query T SELECT 'aaaaa'::char(3) = ' '::char(3); ---- false query T SELECT 'aaaaa'::char(3) > ' '::char(3); ---- true query T SELECT 'aaaaa'::char(3) < ' '::char(3); ---- false query T SELECT 'aaaaa '::char(3) = 'a'::char(3); ---- false query T SELECT 'aaaaa '::char(3) > 'a'::char(3); ---- true query T SELECT 'aaaaa '::char(3) < 'a'::char(3); ---- false query T SELECT 'aaaaa '::char(3) = 'a '::char(3); ---- false query T SELECT 'aaaaa '::char(3) > 'a '::char(3); ---- true query T SELECT 'aaaaa '::char(3) < 'a '::char(3); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa '::char(3) > 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa '::char(3) > 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa '::char(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(3) = ''::char(3); ---- false query T SELECT 'aaaaa '::char(3) > ''::char(3); ---- true query T SELECT 'aaaaa '::char(3) < ''::char(3); ---- false query T SELECT 'aaaaa '::char(3) = ' '::char(3); ---- false query T SELECT 'aaaaa '::char(3) > ' '::char(3); ---- true query T SELECT 'aaaaa '::char(3) < ' '::char(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'a'::char(3); ---- false query T SELECT 'aaaaaa'::char(3) > 'a'::char(3); ---- true query T SELECT 'aaaaaa'::char(3) < 'a'::char(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'a '::char(3); ---- false query T SELECT 'aaaaaa'::char(3) > 'a '::char(3); ---- true query T SELECT 'aaaaaa'::char(3) < 'a '::char(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::char(3) > 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaa '::char(3); ---- true query T SELECT 'aaaaaa'::char(3) > 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::char(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(3) = ''::char(3); ---- false query T SELECT 'aaaaaa'::char(3) > ''::char(3); ---- true query T SELECT 'aaaaaa'::char(3) < ''::char(3); ---- false query T SELECT 'aaaaaa'::char(3) = ' '::char(3); ---- false query T SELECT 'aaaaaa'::char(3) > ' '::char(3); ---- true query T SELECT 'aaaaaa'::char(3) < ' '::char(3); ---- false query T SELECT ''::char(3) = 'a'::char(3); ---- false query T SELECT ''::char(3) > 'a'::char(3); ---- false query T SELECT ''::char(3) < 'a'::char(3); ---- true query T SELECT ''::char(3) = 'a '::char(3); ---- false query T SELECT ''::char(3) > 'a '::char(3); ---- false query T SELECT ''::char(3) < 'a '::char(3); ---- true query T SELECT ''::char(3) = 'aaaaa'::char(3); ---- false query T SELECT ''::char(3) > 'aaaaa'::char(3); ---- false query T SELECT ''::char(3) < 'aaaaa'::char(3); ---- true query T SELECT ''::char(3) = 'aaaaa '::char(3); ---- false query T SELECT ''::char(3) > 'aaaaa '::char(3); ---- false query T SELECT ''::char(3) < 'aaaaa '::char(3); ---- true query T SELECT ''::char(3) = 'aaaaaa'::char(3); ---- false query T SELECT ''::char(3) > 'aaaaaa'::char(3); ---- false query T SELECT ''::char(3) < 'aaaaaa'::char(3); ---- true query T SELECT ''::char(3) = ''::char(3); ---- true query T SELECT ''::char(3) > ''::char(3); ---- false query T SELECT ''::char(3) < ''::char(3); ---- false query T SELECT ''::char(3) = ' '::char(3); ---- true query T SELECT ''::char(3) > ' '::char(3); ---- false query T SELECT ''::char(3) < ' '::char(3); ---- false query T SELECT ' '::char(3) = 'a'::char(3); ---- false query T SELECT ' '::char(3) > 'a'::char(3); ---- false query T SELECT ' '::char(3) < 'a'::char(3); ---- true query T SELECT ' '::char(3) = 'a '::char(3); ---- false query T SELECT ' '::char(3) > 'a '::char(3); ---- false query T SELECT ' '::char(3) < 'a '::char(3); ---- true query T SELECT ' '::char(3) = 'aaaaa'::char(3); ---- false query T SELECT ' '::char(3) > 'aaaaa'::char(3); ---- false query T SELECT ' '::char(3) < 'aaaaa'::char(3); ---- true query T SELECT ' '::char(3) = 'aaaaa '::char(3); ---- false query T SELECT ' '::char(3) > 'aaaaa '::char(3); ---- false query T SELECT ' '::char(3) < 'aaaaa '::char(3); ---- true query T SELECT ' '::char(3) = 'aaaaaa'::char(3); ---- false query T SELECT ' '::char(3) > 'aaaaaa'::char(3); ---- false query T SELECT ' '::char(3) < 'aaaaaa'::char(3); ---- true query T SELECT ' '::char(3) = ''::char(3); ---- true query T SELECT ' '::char(3) > ''::char(3); ---- false query T SELECT ' '::char(3) < ''::char(3); ---- false query T SELECT ' '::char(3) = ' '::char(3); ---- true query T SELECT ' '::char(3) > ' '::char(3); ---- false query T SELECT ' '::char(3) < ' '::char(3); ---- false query T SELECT 'a'::char(3) = 'a'::char(30); ---- true query T SELECT 'a'::char(3) > 'a'::char(30); ---- false query T SELECT 'a'::char(3) < 'a'::char(30); ---- false query T SELECT 'a'::char(3) = 'a '::char(30); ---- true query T SELECT 'a'::char(3) > 'a '::char(30); ---- false query T SELECT 'a'::char(3) < 'a '::char(30); ---- false query T SELECT 'a'::char(3) = 'aaaaa'::char(30); ---- false query T SELECT 'a'::char(3) > 'aaaaa'::char(30); ---- false query T SELECT 'a'::char(3) < 'aaaaa'::char(30); ---- true query T SELECT 'a'::char(3) = 'aaaaa '::char(30); ---- false query T SELECT 'a'::char(3) > 'aaaaa '::char(30); ---- false query T SELECT 'a'::char(3) < 'aaaaa '::char(30); ---- true query T SELECT 'a'::char(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'a'::char(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'a'::char(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'a'::char(3) = ''::char(30); ---- false query T SELECT 'a'::char(3) > ''::char(30); ---- true query T SELECT 'a'::char(3) < ''::char(30); ---- false query T SELECT 'a'::char(3) = ' '::char(30); ---- false query T SELECT 'a'::char(3) > ' '::char(30); ---- true query T SELECT 'a'::char(3) < ' '::char(30); ---- false query T SELECT 'a '::char(3) = 'a'::char(30); ---- true query T SELECT 'a '::char(3) > 'a'::char(30); ---- false query T SELECT 'a '::char(3) < 'a'::char(30); ---- false query T SELECT 'a '::char(3) = 'a '::char(30); ---- true query T SELECT 'a '::char(3) > 'a '::char(30); ---- false query T SELECT 'a '::char(3) < 'a '::char(30); ---- false query T SELECT 'a '::char(3) = 'aaaaa'::char(30); ---- false query T SELECT 'a '::char(3) > 'aaaaa'::char(30); ---- false query T SELECT 'a '::char(3) < 'aaaaa'::char(30); ---- true query T SELECT 'a '::char(3) = 'aaaaa '::char(30); ---- false query T SELECT 'a '::char(3) > 'aaaaa '::char(30); ---- false query T SELECT 'a '::char(3) < 'aaaaa '::char(30); ---- true query T SELECT 'a '::char(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'a '::char(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'a '::char(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'a '::char(3) = ''::char(30); ---- false query T SELECT 'a '::char(3) > ''::char(30); ---- true query T SELECT 'a '::char(3) < ''::char(30); ---- false query T SELECT 'a '::char(3) = ' '::char(30); ---- false query T SELECT 'a '::char(3) > ' '::char(30); ---- true query T SELECT 'a '::char(3) < ' '::char(30); ---- false query T SELECT 'aaaaa'::char(3) = 'a'::char(30); ---- false query T SELECT 'aaaaa'::char(3) > 'a'::char(30); ---- true query T SELECT 'aaaaa'::char(3) < 'a'::char(30); ---- false query T SELECT 'aaaaa'::char(3) = 'a '::char(30); ---- false query T SELECT 'aaaaa'::char(3) > 'a '::char(30); ---- true query T SELECT 'aaaaa'::char(3) < 'a '::char(30); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa'::char(3) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa'::char(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa'::char(3) = ''::char(30); ---- false query T SELECT 'aaaaa'::char(3) > ''::char(30); ---- true query T SELECT 'aaaaa'::char(3) < ''::char(30); ---- false query T SELECT 'aaaaa'::char(3) = ' '::char(30); ---- false query T SELECT 'aaaaa'::char(3) > ' '::char(30); ---- true query T SELECT 'aaaaa'::char(3) < ' '::char(30); ---- false query T SELECT 'aaaaa '::char(3) = 'a'::char(30); ---- false query T SELECT 'aaaaa '::char(3) > 'a'::char(30); ---- true query T SELECT 'aaaaa '::char(3) < 'a'::char(30); ---- false query T SELECT 'aaaaa '::char(3) = 'a '::char(30); ---- false query T SELECT 'aaaaa '::char(3) > 'a '::char(30); ---- true query T SELECT 'aaaaa '::char(3) < 'a '::char(30); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa '::char(3) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa '::char(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa '::char(3) = ''::char(30); ---- false query T SELECT 'aaaaa '::char(3) > ''::char(30); ---- true query T SELECT 'aaaaa '::char(3) < ''::char(30); ---- false query T SELECT 'aaaaa '::char(3) = ' '::char(30); ---- false query T SELECT 'aaaaa '::char(3) > ' '::char(30); ---- true query T SELECT 'aaaaa '::char(3) < ' '::char(30); ---- false query T SELECT 'aaaaaa'::char(3) = 'a'::char(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'a'::char(30); ---- true query T SELECT 'aaaaaa'::char(3) < 'a'::char(30); ---- false query T SELECT 'aaaaaa'::char(3) = 'a '::char(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'a '::char(30); ---- true query T SELECT 'aaaaaa'::char(3) < 'a '::char(30); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::char(3) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa '::char(30); ---- true query T SELECT 'aaaaaa'::char(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::char(3) = ''::char(30); ---- false query T SELECT 'aaaaaa'::char(3) > ''::char(30); ---- true query T SELECT 'aaaaaa'::char(3) < ''::char(30); ---- false query T SELECT 'aaaaaa'::char(3) = ' '::char(30); ---- false query T SELECT 'aaaaaa'::char(3) > ' '::char(30); ---- true query T SELECT 'aaaaaa'::char(3) < ' '::char(30); ---- false query T SELECT ''::char(3) = 'a'::char(30); ---- false query T SELECT ''::char(3) > 'a'::char(30); ---- false query T SELECT ''::char(3) < 'a'::char(30); ---- true query T SELECT ''::char(3) = 'a '::char(30); ---- false query T SELECT ''::char(3) > 'a '::char(30); ---- false query T SELECT ''::char(3) < 'a '::char(30); ---- true query T SELECT ''::char(3) = 'aaaaa'::char(30); ---- false query T SELECT ''::char(3) > 'aaaaa'::char(30); ---- false query T SELECT ''::char(3) < 'aaaaa'::char(30); ---- true query T SELECT ''::char(3) = 'aaaaa '::char(30); ---- false query T SELECT ''::char(3) > 'aaaaa '::char(30); ---- false query T SELECT ''::char(3) < 'aaaaa '::char(30); ---- true query T SELECT ''::char(3) = 'aaaaaa'::char(30); ---- false query T SELECT ''::char(3) > 'aaaaaa'::char(30); ---- false query T SELECT ''::char(3) < 'aaaaaa'::char(30); ---- true query T SELECT ''::char(3) = ''::char(30); ---- true query T SELECT ''::char(3) > ''::char(30); ---- false query T SELECT ''::char(3) < ''::char(30); ---- false query T SELECT ''::char(3) = ' '::char(30); ---- true query T SELECT ''::char(3) > ' '::char(30); ---- false query T SELECT ''::char(3) < ' '::char(30); ---- false query T SELECT ' '::char(3) = 'a'::char(30); ---- false query T SELECT ' '::char(3) > 'a'::char(30); ---- false query T SELECT ' '::char(3) < 'a'::char(30); ---- true query T SELECT ' '::char(3) = 'a '::char(30); ---- false query T SELECT ' '::char(3) > 'a '::char(30); ---- false query T SELECT ' '::char(3) < 'a '::char(30); ---- true query T SELECT ' '::char(3) = 'aaaaa'::char(30); ---- false query T SELECT ' '::char(3) > 'aaaaa'::char(30); ---- false query T SELECT ' '::char(3) < 'aaaaa'::char(30); ---- true query T SELECT ' '::char(3) = 'aaaaa '::char(30); ---- false query T SELECT ' '::char(3) > 'aaaaa '::char(30); ---- false query T SELECT ' '::char(3) < 'aaaaa '::char(30); ---- true query T SELECT ' '::char(3) = 'aaaaaa'::char(30); ---- false query T SELECT ' '::char(3) > 'aaaaaa'::char(30); ---- false query T SELECT ' '::char(3) < 'aaaaaa'::char(30); ---- true query T SELECT ' '::char(3) = ''::char(30); ---- true query T SELECT ' '::char(3) > ''::char(30); ---- false query T SELECT ' '::char(3) < ''::char(30); ---- false query T SELECT ' '::char(3) = ' '::char(30); ---- true query T SELECT ' '::char(3) > ' '::char(30); ---- false query T SELECT ' '::char(3) < ' '::char(30); ---- false query T SELECT 'a'::char(3) = 'a'::varchar(3); ---- true query T SELECT 'a'::char(3) > 'a'::varchar(3); ---- false query T SELECT 'a'::char(3) < 'a'::varchar(3); ---- false query T SELECT 'a'::char(3) = 'a '::varchar(3); ---- true query T SELECT 'a'::char(3) > 'a '::varchar(3); ---- false query T SELECT 'a'::char(3) < 'a '::varchar(3); ---- false query T SELECT 'a'::char(3) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::char(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::char(3) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a'::char(3) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::char(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::char(3) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a'::char(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::char(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::char(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a'::char(3) = ''::varchar(3); ---- false query T SELECT 'a'::char(3) > ''::varchar(3); ---- true query T SELECT 'a'::char(3) < ''::varchar(3); ---- false query T SELECT 'a'::char(3) = ' '::varchar(3); ---- false query T SELECT 'a'::char(3) > ' '::varchar(3); ---- true query T SELECT 'a'::char(3) < ' '::varchar(3); ---- false query T SELECT 'a '::char(3) = 'a'::varchar(3); ---- true query T SELECT 'a '::char(3) > 'a'::varchar(3); ---- false query T SELECT 'a '::char(3) < 'a'::varchar(3); ---- false query T SELECT 'a '::char(3) = 'a '::varchar(3); ---- true query T SELECT 'a '::char(3) > 'a '::varchar(3); ---- false query T SELECT 'a '::char(3) < 'a '::varchar(3); ---- false query T SELECT 'a '::char(3) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::char(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::char(3) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a '::char(3) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::char(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::char(3) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a '::char(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::char(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::char(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a '::char(3) = ''::varchar(3); ---- false query T SELECT 'a '::char(3) > ''::varchar(3); ---- true query T SELECT 'a '::char(3) < ''::varchar(3); ---- false query T SELECT 'a '::char(3) = ' '::varchar(3); ---- false query T SELECT 'a '::char(3) > ' '::varchar(3); ---- true query T SELECT 'a '::char(3) < ' '::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa'::char(3) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa'::char(3) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::char(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa'::char(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::char(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) = ''::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) > ''::varchar(3); ---- true query T SELECT 'aaaaa'::char(3) < ''::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) = ' '::varchar(3); ---- false query T SELECT 'aaaaa'::char(3) > ' '::varchar(3); ---- true query T SELECT 'aaaaa'::char(3) < ' '::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa '::char(3) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa '::char(3) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::char(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa '::char(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::char(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) = ''::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) > ''::varchar(3); ---- true query T SELECT 'aaaaa '::char(3) < ''::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) = ' '::varchar(3); ---- false query T SELECT 'aaaaa '::char(3) > ' '::varchar(3); ---- true query T SELECT 'aaaaa '::char(3) < ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) > 'a'::varchar(3); ---- true query T SELECT 'aaaaaa'::char(3) < 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) > 'a '::varchar(3); ---- true query T SELECT 'aaaaaa'::char(3) < 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::char(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaaa'::char(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::char(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) = ''::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) > ''::varchar(3); ---- true query T SELECT 'aaaaaa'::char(3) < ''::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) = ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(3) > ' '::varchar(3); ---- true query T SELECT 'aaaaaa'::char(3) < ' '::varchar(3); ---- false query T SELECT ''::char(3) = 'a'::varchar(3); ---- false query T SELECT ''::char(3) > 'a'::varchar(3); ---- false query T SELECT ''::char(3) < 'a'::varchar(3); ---- true query T SELECT ''::char(3) = 'a '::varchar(3); ---- false query T SELECT ''::char(3) > 'a '::varchar(3); ---- false query T SELECT ''::char(3) < 'a '::varchar(3); ---- true query T SELECT ''::char(3) = 'aaaaa'::varchar(3); ---- false query T SELECT ''::char(3) > 'aaaaa'::varchar(3); ---- false query T SELECT ''::char(3) < 'aaaaa'::varchar(3); ---- true query T SELECT ''::char(3) = 'aaaaa '::varchar(3); ---- false query T SELECT ''::char(3) > 'aaaaa '::varchar(3); ---- false query T SELECT ''::char(3) < 'aaaaa '::varchar(3); ---- true query T SELECT ''::char(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT ''::char(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT ''::char(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT ''::char(3) = ''::varchar(3); ---- true query T SELECT ''::char(3) > ''::varchar(3); ---- false query T SELECT ''::char(3) < ''::varchar(3); ---- false query T SELECT ''::char(3) = ' '::varchar(3); ---- true query T SELECT ''::char(3) > ' '::varchar(3); ---- false query T SELECT ''::char(3) < ' '::varchar(3); ---- false query T SELECT ' '::char(3) = 'a'::varchar(3); ---- false query T SELECT ' '::char(3) > 'a'::varchar(3); ---- false query T SELECT ' '::char(3) < 'a'::varchar(3); ---- true query T SELECT ' '::char(3) = 'a '::varchar(3); ---- false query T SELECT ' '::char(3) > 'a '::varchar(3); ---- false query T SELECT ' '::char(3) < 'a '::varchar(3); ---- true query T SELECT ' '::char(3) = 'aaaaa'::varchar(3); ---- false query T SELECT ' '::char(3) > 'aaaaa'::varchar(3); ---- false query T SELECT ' '::char(3) < 'aaaaa'::varchar(3); ---- true query T SELECT ' '::char(3) = 'aaaaa '::varchar(3); ---- false query T SELECT ' '::char(3) > 'aaaaa '::varchar(3); ---- false query T SELECT ' '::char(3) < 'aaaaa '::varchar(3); ---- true query T SELECT ' '::char(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::char(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::char(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT ' '::char(3) = ''::varchar(3); ---- true query T SELECT ' '::char(3) > ''::varchar(3); ---- false query T SELECT ' '::char(3) < ''::varchar(3); ---- false query T SELECT ' '::char(3) = ' '::varchar(3); ---- true query T SELECT ' '::char(3) > ' '::varchar(3); ---- false query T SELECT ' '::char(3) < ' '::varchar(3); ---- false query T SELECT 'a'::char(3) = 'a'::varchar(30); ---- true query T SELECT 'a'::char(3) > 'a'::varchar(30); ---- false query T SELECT 'a'::char(3) < 'a'::varchar(30); ---- false query T SELECT 'a'::char(3) = 'a '::varchar(30); ---- true query T SELECT 'a'::char(3) > 'a '::varchar(30); ---- false query T SELECT 'a'::char(3) < 'a '::varchar(30); ---- false query T SELECT 'a'::char(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::char(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::char(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a'::char(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::char(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::char(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a'::char(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::char(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::char(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a'::char(3) = ''::varchar(30); ---- false query T SELECT 'a'::char(3) > ''::varchar(30); ---- true query T SELECT 'a'::char(3) < ''::varchar(30); ---- false query T SELECT 'a'::char(3) = ' '::varchar(30); ---- false query T SELECT 'a'::char(3) > ' '::varchar(30); ---- true query T SELECT 'a'::char(3) < ' '::varchar(30); ---- false query T SELECT 'a '::char(3) = 'a'::varchar(30); ---- true query T SELECT 'a '::char(3) > 'a'::varchar(30); ---- false query T SELECT 'a '::char(3) < 'a'::varchar(30); ---- false query T SELECT 'a '::char(3) = 'a '::varchar(30); ---- true query T SELECT 'a '::char(3) > 'a '::varchar(30); ---- false query T SELECT 'a '::char(3) < 'a '::varchar(30); ---- false query T SELECT 'a '::char(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::char(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::char(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a '::char(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::char(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::char(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a '::char(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::char(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::char(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a '::char(3) = ''::varchar(30); ---- false query T SELECT 'a '::char(3) > ''::varchar(30); ---- true query T SELECT 'a '::char(3) < ''::varchar(30); ---- false query T SELECT 'a '::char(3) = ' '::varchar(30); ---- false query T SELECT 'a '::char(3) > ' '::varchar(30); ---- true query T SELECT 'a '::char(3) < ' '::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa'::char(3) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa'::char(3) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::char(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa'::char(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::char(3) = ''::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) > ''::varchar(30); ---- true query T SELECT 'aaaaa'::char(3) < ''::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) = ' '::varchar(30); ---- false query T SELECT 'aaaaa'::char(3) > ' '::varchar(30); ---- true query T SELECT 'aaaaa'::char(3) < ' '::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa '::char(3) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa '::char(3) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::char(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa '::char(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::char(3) = ''::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) > ''::varchar(30); ---- true query T SELECT 'aaaaa '::char(3) < ''::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) = ' '::varchar(30); ---- false query T SELECT 'aaaaa '::char(3) > ' '::varchar(30); ---- true query T SELECT 'aaaaa '::char(3) < ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) = 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'a'::varchar(30); ---- true query T SELECT 'aaaaaa'::char(3) < 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) = 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'a '::varchar(30); ---- true query T SELECT 'aaaaaa'::char(3) < 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::char(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaaa'::char(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::char(3) = ''::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) > ''::varchar(30); ---- true query T SELECT 'aaaaaa'::char(3) < ''::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) = ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(3) > ' '::varchar(30); ---- true query T SELECT 'aaaaaa'::char(3) < ' '::varchar(30); ---- false query T SELECT ''::char(3) = 'a'::varchar(30); ---- false query T SELECT ''::char(3) > 'a'::varchar(30); ---- false query T SELECT ''::char(3) < 'a'::varchar(30); ---- true query T SELECT ''::char(3) = 'a '::varchar(30); ---- false query T SELECT ''::char(3) > 'a '::varchar(30); ---- false query T SELECT ''::char(3) < 'a '::varchar(30); ---- true query T SELECT ''::char(3) = 'aaaaa'::varchar(30); ---- false query T SELECT ''::char(3) > 'aaaaa'::varchar(30); ---- false query T SELECT ''::char(3) < 'aaaaa'::varchar(30); ---- true query T SELECT ''::char(3) = 'aaaaa '::varchar(30); ---- false query T SELECT ''::char(3) > 'aaaaa '::varchar(30); ---- false query T SELECT ''::char(3) < 'aaaaa '::varchar(30); ---- true query T SELECT ''::char(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT ''::char(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT ''::char(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT ''::char(3) = ''::varchar(30); ---- true query T SELECT ''::char(3) > ''::varchar(30); ---- false query T SELECT ''::char(3) < ''::varchar(30); ---- false query T SELECT ''::char(3) = ' '::varchar(30); ---- true query T SELECT ''::char(3) > ' '::varchar(30); ---- false query T SELECT ''::char(3) < ' '::varchar(30); ---- false query T SELECT ' '::char(3) = 'a'::varchar(30); ---- false query T SELECT ' '::char(3) > 'a'::varchar(30); ---- false query T SELECT ' '::char(3) < 'a'::varchar(30); ---- true query T SELECT ' '::char(3) = 'a '::varchar(30); ---- false query T SELECT ' '::char(3) > 'a '::varchar(30); ---- false query T SELECT ' '::char(3) < 'a '::varchar(30); ---- true query T SELECT ' '::char(3) = 'aaaaa'::varchar(30); ---- false query T SELECT ' '::char(3) > 'aaaaa'::varchar(30); ---- false query T SELECT ' '::char(3) < 'aaaaa'::varchar(30); ---- true query T SELECT ' '::char(3) = 'aaaaa '::varchar(30); ---- false query T SELECT ' '::char(3) > 'aaaaa '::varchar(30); ---- false query T SELECT ' '::char(3) < 'aaaaa '::varchar(30); ---- true query T SELECT ' '::char(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::char(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::char(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT ' '::char(3) = ''::varchar(30); ---- true query T SELECT ' '::char(3) > ''::varchar(30); ---- false query T SELECT ' '::char(3) < ''::varchar(30); ---- false query T SELECT ' '::char(3) = ' '::varchar(30); ---- true query T SELECT ' '::char(3) > ' '::varchar(30); ---- false query T SELECT ' '::char(3) < ' '::varchar(30); ---- false query T SELECT 'a'::char(3) = 'a'::text; ---- true query T SELECT 'a'::char(3) > 'a'::text; ---- false query T SELECT 'a'::char(3) < 'a'::text; ---- false query T SELECT 'a'::char(3) = 'a '::text; ---- false query T SELECT 'a'::char(3) > 'a '::text; ---- false query T SELECT 'a'::char(3) < 'a '::text; ---- true query T SELECT 'a'::char(3) = 'aaaaa'::text; ---- false query T SELECT 'a'::char(3) > 'aaaaa'::text; ---- false query T SELECT 'a'::char(3) < 'aaaaa'::text; ---- true query T SELECT 'a'::char(3) = 'aaaaa '::text; ---- false query T SELECT 'a'::char(3) > 'aaaaa '::text; ---- false query T SELECT 'a'::char(3) < 'aaaaa '::text; ---- true query T SELECT 'a'::char(3) = 'aaaaaa'::text; ---- false query T SELECT 'a'::char(3) > 'aaaaaa'::text; ---- false query T SELECT 'a'::char(3) < 'aaaaaa'::text; ---- true query T SELECT 'a'::char(3) = ''::text; ---- false query T SELECT 'a'::char(3) > ''::text; ---- true query T SELECT 'a'::char(3) < ''::text; ---- false query T SELECT 'a'::char(3) = ' '::text; ---- false query T SELECT 'a'::char(3) > ' '::text; ---- true query T SELECT 'a'::char(3) < ' '::text; ---- false query T SELECT 'a '::char(3) = 'a'::text; ---- true query T SELECT 'a '::char(3) > 'a'::text; ---- false query T SELECT 'a '::char(3) < 'a'::text; ---- false query T SELECT 'a '::char(3) = 'a '::text; ---- false query T SELECT 'a '::char(3) > 'a '::text; ---- false query T SELECT 'a '::char(3) < 'a '::text; ---- true query T SELECT 'a '::char(3) = 'aaaaa'::text; ---- false query T SELECT 'a '::char(3) > 'aaaaa'::text; ---- false query T SELECT 'a '::char(3) < 'aaaaa'::text; ---- true query T SELECT 'a '::char(3) = 'aaaaa '::text; ---- false query T SELECT 'a '::char(3) > 'aaaaa '::text; ---- false query T SELECT 'a '::char(3) < 'aaaaa '::text; ---- true query T SELECT 'a '::char(3) = 'aaaaaa'::text; ---- false query T SELECT 'a '::char(3) > 'aaaaaa'::text; ---- false query T SELECT 'a '::char(3) < 'aaaaaa'::text; ---- true query T SELECT 'a '::char(3) = ''::text; ---- false query T SELECT 'a '::char(3) > ''::text; ---- true query T SELECT 'a '::char(3) < ''::text; ---- false query T SELECT 'a '::char(3) = ' '::text; ---- false query T SELECT 'a '::char(3) > ' '::text; ---- true query T SELECT 'a '::char(3) < ' '::text; ---- false query T SELECT 'aaaaa'::char(3) = 'a'::text; ---- false query T SELECT 'aaaaa'::char(3) > 'a'::text; ---- true query T SELECT 'aaaaa'::char(3) < 'a'::text; ---- false query T SELECT 'aaaaa'::char(3) = 'a '::text; ---- false query T SELECT 'aaaaa'::char(3) > 'a '::text; ---- true query T SELECT 'aaaaa'::char(3) < 'a '::text; ---- false query T SELECT 'aaaaa'::char(3) = 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa'::text; ---- true query T SELECT 'aaaaa'::char(3) = 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaa '::text; ---- true query T SELECT 'aaaaa'::char(3) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::char(3) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::char(3) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa'::char(3) = ''::text; ---- false query T SELECT 'aaaaa'::char(3) > ''::text; ---- true query T SELECT 'aaaaa'::char(3) < ''::text; ---- false query T SELECT 'aaaaa'::char(3) = ' '::text; ---- false query T SELECT 'aaaaa'::char(3) > ' '::text; ---- true query T SELECT 'aaaaa'::char(3) < ' '::text; ---- false query T SELECT 'aaaaa '::char(3) = 'a'::text; ---- false query T SELECT 'aaaaa '::char(3) > 'a'::text; ---- true query T SELECT 'aaaaa '::char(3) < 'a'::text; ---- false query T SELECT 'aaaaa '::char(3) = 'a '::text; ---- false query T SELECT 'aaaaa '::char(3) > 'a '::text; ---- true query T SELECT 'aaaaa '::char(3) < 'a '::text; ---- false query T SELECT 'aaaaa '::char(3) = 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa'::text; ---- true query T SELECT 'aaaaa '::char(3) = 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaa '::text; ---- true query T SELECT 'aaaaa '::char(3) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::char(3) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::char(3) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa '::char(3) = ''::text; ---- false query T SELECT 'aaaaa '::char(3) > ''::text; ---- true query T SELECT 'aaaaa '::char(3) < ''::text; ---- false query T SELECT 'aaaaa '::char(3) = ' '::text; ---- false query T SELECT 'aaaaa '::char(3) > ' '::text; ---- true query T SELECT 'aaaaa '::char(3) < ' '::text; ---- false query T SELECT 'aaaaaa'::char(3) = 'a'::text; ---- false query T SELECT 'aaaaaa'::char(3) > 'a'::text; ---- true query T SELECT 'aaaaaa'::char(3) < 'a'::text; ---- false query T SELECT 'aaaaaa'::char(3) = 'a '::text; ---- false query T SELECT 'aaaaaa'::char(3) > 'a '::text; ---- true query T SELECT 'aaaaaa'::char(3) < 'a '::text; ---- false query T SELECT 'aaaaaa'::char(3) = 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa'::text; ---- true query T SELECT 'aaaaaa'::char(3) = 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaa '::text; ---- true query T SELECT 'aaaaaa'::char(3) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(3) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(3) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaaa'::char(3) = ''::text; ---- false query T SELECT 'aaaaaa'::char(3) > ''::text; ---- true query T SELECT 'aaaaaa'::char(3) < ''::text; ---- false query T SELECT 'aaaaaa'::char(3) = ' '::text; ---- false query T SELECT 'aaaaaa'::char(3) > ' '::text; ---- true query T SELECT 'aaaaaa'::char(3) < ' '::text; ---- false query T SELECT ''::char(3) = 'a'::text; ---- false query T SELECT ''::char(3) > 'a'::text; ---- false query T SELECT ''::char(3) < 'a'::text; ---- true query T SELECT ''::char(3) = 'a '::text; ---- false query T SELECT ''::char(3) > 'a '::text; ---- false query T SELECT ''::char(3) < 'a '::text; ---- true query T SELECT ''::char(3) = 'aaaaa'::text; ---- false query T SELECT ''::char(3) > 'aaaaa'::text; ---- false query T SELECT ''::char(3) < 'aaaaa'::text; ---- true query T SELECT ''::char(3) = 'aaaaa '::text; ---- false query T SELECT ''::char(3) > 'aaaaa '::text; ---- false query T SELECT ''::char(3) < 'aaaaa '::text; ---- true query T SELECT ''::char(3) = 'aaaaaa'::text; ---- false query T SELECT ''::char(3) > 'aaaaaa'::text; ---- false query T SELECT ''::char(3) < 'aaaaaa'::text; ---- true query T SELECT ''::char(3) = ''::text; ---- true query T SELECT ''::char(3) > ''::text; ---- false query T SELECT ''::char(3) < ''::text; ---- false query T SELECT ''::char(3) = ' '::text; ---- false query T SELECT ''::char(3) > ' '::text; ---- false query T SELECT ''::char(3) < ' '::text; ---- true query T SELECT ' '::char(3) = 'a'::text; ---- false query T SELECT ' '::char(3) > 'a'::text; ---- false query T SELECT ' '::char(3) < 'a'::text; ---- true query T SELECT ' '::char(3) = 'a '::text; ---- false query T SELECT ' '::char(3) > 'a '::text; ---- false query T SELECT ' '::char(3) < 'a '::text; ---- true query T SELECT ' '::char(3) = 'aaaaa'::text; ---- false query T SELECT ' '::char(3) > 'aaaaa'::text; ---- false query T SELECT ' '::char(3) < 'aaaaa'::text; ---- true query T SELECT ' '::char(3) = 'aaaaa '::text; ---- false query T SELECT ' '::char(3) > 'aaaaa '::text; ---- false query T SELECT ' '::char(3) < 'aaaaa '::text; ---- true query T SELECT ' '::char(3) = 'aaaaaa'::text; ---- false query T SELECT ' '::char(3) > 'aaaaaa'::text; ---- false query T SELECT ' '::char(3) < 'aaaaaa'::text; ---- true query T SELECT ' '::char(3) = ''::text; ---- true query T SELECT ' '::char(3) > ''::text; ---- false query T SELECT ' '::char(3) < ''::text; ---- false query T SELECT ' '::char(3) = ' '::text; ---- false query T SELECT ' '::char(3) > ' '::text; ---- false query T SELECT ' '::char(3) < ' '::text; ---- true query T SELECT 'a'::char(30) = 'a'::char(3); ---- true query T SELECT 'a'::char(30) > 'a'::char(3); ---- false query T SELECT 'a'::char(30) < 'a'::char(3); ---- false query T SELECT 'a'::char(30) = 'a '::char(3); ---- true query T SELECT 'a'::char(30) > 'a '::char(3); ---- false query T SELECT 'a'::char(30) < 'a '::char(3); ---- false query T SELECT 'a'::char(30) = 'aaaaa'::char(3); ---- false query T SELECT 'a'::char(30) > 'aaaaa'::char(3); ---- false query T SELECT 'a'::char(30) < 'aaaaa'::char(3); ---- true query T SELECT 'a'::char(30) = 'aaaaa '::char(3); ---- false query T SELECT 'a'::char(30) > 'aaaaa '::char(3); ---- false query T SELECT 'a'::char(30) < 'aaaaa '::char(3); ---- true query T SELECT 'a'::char(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'a'::char(30) > 'aaaaaa'::char(3); ---- false query T SELECT 'a'::char(30) < 'aaaaaa'::char(3); ---- true query T SELECT 'a'::char(30) = ''::char(3); ---- false query T SELECT 'a'::char(30) > ''::char(3); ---- true query T SELECT 'a'::char(30) < ''::char(3); ---- false query T SELECT 'a'::char(30) = ' '::char(3); ---- false query T SELECT 'a'::char(30) > ' '::char(3); ---- true query T SELECT 'a'::char(30) < ' '::char(3); ---- false query T SELECT 'a '::char(30) = 'a'::char(3); ---- true query T SELECT 'a '::char(30) > 'a'::char(3); ---- false query T SELECT 'a '::char(30) < 'a'::char(3); ---- false query T SELECT 'a '::char(30) = 'a '::char(3); ---- true query T SELECT 'a '::char(30) > 'a '::char(3); ---- false query T SELECT 'a '::char(30) < 'a '::char(3); ---- false query T SELECT 'a '::char(30) = 'aaaaa'::char(3); ---- false query T SELECT 'a '::char(30) > 'aaaaa'::char(3); ---- false query T SELECT 'a '::char(30) < 'aaaaa'::char(3); ---- true query T SELECT 'a '::char(30) = 'aaaaa '::char(3); ---- false query T SELECT 'a '::char(30) > 'aaaaa '::char(3); ---- false query T SELECT 'a '::char(30) < 'aaaaa '::char(3); ---- true query T SELECT 'a '::char(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'a '::char(30) > 'aaaaaa'::char(3); ---- false query T SELECT 'a '::char(30) < 'aaaaaa'::char(3); ---- true query T SELECT 'a '::char(30) = ''::char(3); ---- false query T SELECT 'a '::char(30) > ''::char(3); ---- true query T SELECT 'a '::char(30) < ''::char(3); ---- false query T SELECT 'a '::char(30) = ' '::char(3); ---- false query T SELECT 'a '::char(30) > ' '::char(3); ---- true query T SELECT 'a '::char(30) < ' '::char(3); ---- false query T SELECT 'aaaaa'::char(30) = 'a'::char(3); ---- false query T SELECT 'aaaaa'::char(30) > 'a'::char(3); ---- true query T SELECT 'aaaaa'::char(30) < 'a'::char(3); ---- false query T SELECT 'aaaaa'::char(30) = 'a '::char(3); ---- false query T SELECT 'aaaaa'::char(30) > 'a '::char(3); ---- true query T SELECT 'aaaaa'::char(30) < 'a '::char(3); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa'::char(30) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa'::char(30) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa'::char(30) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::char(30) = ''::char(3); ---- false query T SELECT 'aaaaa'::char(30) > ''::char(3); ---- true query T SELECT 'aaaaa'::char(30) < ''::char(3); ---- false query T SELECT 'aaaaa'::char(30) = ' '::char(3); ---- false query T SELECT 'aaaaa'::char(30) > ' '::char(3); ---- true query T SELECT 'aaaaa'::char(30) < ' '::char(3); ---- false query T SELECT 'aaaaa '::char(30) = 'a'::char(3); ---- false query T SELECT 'aaaaa '::char(30) > 'a'::char(3); ---- true query T SELECT 'aaaaa '::char(30) < 'a'::char(3); ---- false query T SELECT 'aaaaa '::char(30) = 'a '::char(3); ---- false query T SELECT 'aaaaa '::char(30) > 'a '::char(3); ---- true query T SELECT 'aaaaa '::char(30) < 'a '::char(3); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa '::char(30) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa '::char(30) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa '::char(30) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::char(30) = ''::char(3); ---- false query T SELECT 'aaaaa '::char(30) > ''::char(3); ---- true query T SELECT 'aaaaa '::char(30) < ''::char(3); ---- false query T SELECT 'aaaaa '::char(30) = ' '::char(3); ---- false query T SELECT 'aaaaa '::char(30) > ' '::char(3); ---- true query T SELECT 'aaaaa '::char(30) < ' '::char(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'a'::char(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'a'::char(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'a'::char(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'a '::char(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'a '::char(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'a '::char(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::char(30) = ''::char(3); ---- false query T SELECT 'aaaaaa'::char(30) > ''::char(3); ---- true query T SELECT 'aaaaaa'::char(30) < ''::char(3); ---- false query T SELECT 'aaaaaa'::char(30) = ' '::char(3); ---- false query T SELECT 'aaaaaa'::char(30) > ' '::char(3); ---- true query T SELECT 'aaaaaa'::char(30) < ' '::char(3); ---- false query T SELECT ''::char(30) = 'a'::char(3); ---- false query T SELECT ''::char(30) > 'a'::char(3); ---- false query T SELECT ''::char(30) < 'a'::char(3); ---- true query T SELECT ''::char(30) = 'a '::char(3); ---- false query T SELECT ''::char(30) > 'a '::char(3); ---- false query T SELECT ''::char(30) < 'a '::char(3); ---- true query T SELECT ''::char(30) = 'aaaaa'::char(3); ---- false query T SELECT ''::char(30) > 'aaaaa'::char(3); ---- false query T SELECT ''::char(30) < 'aaaaa'::char(3); ---- true query T SELECT ''::char(30) = 'aaaaa '::char(3); ---- false query T SELECT ''::char(30) > 'aaaaa '::char(3); ---- false query T SELECT ''::char(30) < 'aaaaa '::char(3); ---- true query T SELECT ''::char(30) = 'aaaaaa'::char(3); ---- false query T SELECT ''::char(30) > 'aaaaaa'::char(3); ---- false query T SELECT ''::char(30) < 'aaaaaa'::char(3); ---- true query T SELECT ''::char(30) = ''::char(3); ---- true query T SELECT ''::char(30) > ''::char(3); ---- false query T SELECT ''::char(30) < ''::char(3); ---- false query T SELECT ''::char(30) = ' '::char(3); ---- true query T SELECT ''::char(30) > ' '::char(3); ---- false query T SELECT ''::char(30) < ' '::char(3); ---- false query T SELECT ' '::char(30) = 'a'::char(3); ---- false query T SELECT ' '::char(30) > 'a'::char(3); ---- false query T SELECT ' '::char(30) < 'a'::char(3); ---- true query T SELECT ' '::char(30) = 'a '::char(3); ---- false query T SELECT ' '::char(30) > 'a '::char(3); ---- false query T SELECT ' '::char(30) < 'a '::char(3); ---- true query T SELECT ' '::char(30) = 'aaaaa'::char(3); ---- false query T SELECT ' '::char(30) > 'aaaaa'::char(3); ---- false query T SELECT ' '::char(30) < 'aaaaa'::char(3); ---- true query T SELECT ' '::char(30) = 'aaaaa '::char(3); ---- false query T SELECT ' '::char(30) > 'aaaaa '::char(3); ---- false query T SELECT ' '::char(30) < 'aaaaa '::char(3); ---- true query T SELECT ' '::char(30) = 'aaaaaa'::char(3); ---- false query T SELECT ' '::char(30) > 'aaaaaa'::char(3); ---- false query T SELECT ' '::char(30) < 'aaaaaa'::char(3); ---- true query T SELECT ' '::char(30) = ''::char(3); ---- true query T SELECT ' '::char(30) > ''::char(3); ---- false query T SELECT ' '::char(30) < ''::char(3); ---- false query T SELECT ' '::char(30) = ' '::char(3); ---- true query T SELECT ' '::char(30) > ' '::char(3); ---- false query T SELECT ' '::char(30) < ' '::char(3); ---- false query T SELECT 'a'::char(30) = 'a'::char(30); ---- true query T SELECT 'a'::char(30) > 'a'::char(30); ---- false query T SELECT 'a'::char(30) < 'a'::char(30); ---- false query T SELECT 'a'::char(30) = 'a '::char(30); ---- true query T SELECT 'a'::char(30) > 'a '::char(30); ---- false query T SELECT 'a'::char(30) < 'a '::char(30); ---- false query T SELECT 'a'::char(30) = 'aaaaa'::char(30); ---- false query T SELECT 'a'::char(30) > 'aaaaa'::char(30); ---- false query T SELECT 'a'::char(30) < 'aaaaa'::char(30); ---- true query T SELECT 'a'::char(30) = 'aaaaa '::char(30); ---- false query T SELECT 'a'::char(30) > 'aaaaa '::char(30); ---- false query T SELECT 'a'::char(30) < 'aaaaa '::char(30); ---- true query T SELECT 'a'::char(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'a'::char(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'a'::char(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'a'::char(30) = ''::char(30); ---- false query T SELECT 'a'::char(30) > ''::char(30); ---- true query T SELECT 'a'::char(30) < ''::char(30); ---- false query T SELECT 'a'::char(30) = ' '::char(30); ---- false query T SELECT 'a'::char(30) > ' '::char(30); ---- true query T SELECT 'a'::char(30) < ' '::char(30); ---- false query T SELECT 'a '::char(30) = 'a'::char(30); ---- true query T SELECT 'a '::char(30) > 'a'::char(30); ---- false query T SELECT 'a '::char(30) < 'a'::char(30); ---- false query T SELECT 'a '::char(30) = 'a '::char(30); ---- true query T SELECT 'a '::char(30) > 'a '::char(30); ---- false query T SELECT 'a '::char(30) < 'a '::char(30); ---- false query T SELECT 'a '::char(30) = 'aaaaa'::char(30); ---- false query T SELECT 'a '::char(30) > 'aaaaa'::char(30); ---- false query T SELECT 'a '::char(30) < 'aaaaa'::char(30); ---- true query T SELECT 'a '::char(30) = 'aaaaa '::char(30); ---- false query T SELECT 'a '::char(30) > 'aaaaa '::char(30); ---- false query T SELECT 'a '::char(30) < 'aaaaa '::char(30); ---- true query T SELECT 'a '::char(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'a '::char(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'a '::char(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'a '::char(30) = ''::char(30); ---- false query T SELECT 'a '::char(30) > ''::char(30); ---- true query T SELECT 'a '::char(30) < ''::char(30); ---- false query T SELECT 'a '::char(30) = ' '::char(30); ---- false query T SELECT 'a '::char(30) > ' '::char(30); ---- true query T SELECT 'a '::char(30) < ' '::char(30); ---- false query T SELECT 'aaaaa'::char(30) = 'a'::char(30); ---- false query T SELECT 'aaaaa'::char(30) > 'a'::char(30); ---- true query T SELECT 'aaaaa'::char(30) < 'a'::char(30); ---- false query T SELECT 'aaaaa'::char(30) = 'a '::char(30); ---- false query T SELECT 'aaaaa'::char(30) > 'a '::char(30); ---- true query T SELECT 'aaaaa'::char(30) < 'a '::char(30); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa'::char(30) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa'::char(30) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa'::char(30) = ''::char(30); ---- false query T SELECT 'aaaaa'::char(30) > ''::char(30); ---- true query T SELECT 'aaaaa'::char(30) < ''::char(30); ---- false query T SELECT 'aaaaa'::char(30) = ' '::char(30); ---- false query T SELECT 'aaaaa'::char(30) > ' '::char(30); ---- true query T SELECT 'aaaaa'::char(30) < ' '::char(30); ---- false query T SELECT 'aaaaa '::char(30) = 'a'::char(30); ---- false query T SELECT 'aaaaa '::char(30) > 'a'::char(30); ---- true query T SELECT 'aaaaa '::char(30) < 'a'::char(30); ---- false query T SELECT 'aaaaa '::char(30) = 'a '::char(30); ---- false query T SELECT 'aaaaa '::char(30) > 'a '::char(30); ---- true query T SELECT 'aaaaa '::char(30) < 'a '::char(30); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa '::char(30) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa '::char(30) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa '::char(30) = ''::char(30); ---- false query T SELECT 'aaaaa '::char(30) > ''::char(30); ---- true query T SELECT 'aaaaa '::char(30) < ''::char(30); ---- false query T SELECT 'aaaaa '::char(30) = ' '::char(30); ---- false query T SELECT 'aaaaa '::char(30) > ' '::char(30); ---- true query T SELECT 'aaaaa '::char(30) < ' '::char(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'a'::char(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'a'::char(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'a'::char(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'a '::char(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'a '::char(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'a '::char(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa '::char(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::char(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(30) < 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::char(30) = ''::char(30); ---- false query T SELECT 'aaaaaa'::char(30) > ''::char(30); ---- true query T SELECT 'aaaaaa'::char(30) < ''::char(30); ---- false query T SELECT 'aaaaaa'::char(30) = ' '::char(30); ---- false query T SELECT 'aaaaaa'::char(30) > ' '::char(30); ---- true query T SELECT 'aaaaaa'::char(30) < ' '::char(30); ---- false query T SELECT ''::char(30) = 'a'::char(30); ---- false query T SELECT ''::char(30) > 'a'::char(30); ---- false query T SELECT ''::char(30) < 'a'::char(30); ---- true query T SELECT ''::char(30) = 'a '::char(30); ---- false query T SELECT ''::char(30) > 'a '::char(30); ---- false query T SELECT ''::char(30) < 'a '::char(30); ---- true query T SELECT ''::char(30) = 'aaaaa'::char(30); ---- false query T SELECT ''::char(30) > 'aaaaa'::char(30); ---- false query T SELECT ''::char(30) < 'aaaaa'::char(30); ---- true query T SELECT ''::char(30) = 'aaaaa '::char(30); ---- false query T SELECT ''::char(30) > 'aaaaa '::char(30); ---- false query T SELECT ''::char(30) < 'aaaaa '::char(30); ---- true query T SELECT ''::char(30) = 'aaaaaa'::char(30); ---- false query T SELECT ''::char(30) > 'aaaaaa'::char(30); ---- false query T SELECT ''::char(30) < 'aaaaaa'::char(30); ---- true query T SELECT ''::char(30) = ''::char(30); ---- true query T SELECT ''::char(30) > ''::char(30); ---- false query T SELECT ''::char(30) < ''::char(30); ---- false query T SELECT ''::char(30) = ' '::char(30); ---- true query T SELECT ''::char(30) > ' '::char(30); ---- false query T SELECT ''::char(30) < ' '::char(30); ---- false query T SELECT ' '::char(30) = 'a'::char(30); ---- false query T SELECT ' '::char(30) > 'a'::char(30); ---- false query T SELECT ' '::char(30) < 'a'::char(30); ---- true query T SELECT ' '::char(30) = 'a '::char(30); ---- false query T SELECT ' '::char(30) > 'a '::char(30); ---- false query T SELECT ' '::char(30) < 'a '::char(30); ---- true query T SELECT ' '::char(30) = 'aaaaa'::char(30); ---- false query T SELECT ' '::char(30) > 'aaaaa'::char(30); ---- false query T SELECT ' '::char(30) < 'aaaaa'::char(30); ---- true query T SELECT ' '::char(30) = 'aaaaa '::char(30); ---- false query T SELECT ' '::char(30) > 'aaaaa '::char(30); ---- false query T SELECT ' '::char(30) < 'aaaaa '::char(30); ---- true query T SELECT ' '::char(30) = 'aaaaaa'::char(30); ---- false query T SELECT ' '::char(30) > 'aaaaaa'::char(30); ---- false query T SELECT ' '::char(30) < 'aaaaaa'::char(30); ---- true query T SELECT ' '::char(30) = ''::char(30); ---- true query T SELECT ' '::char(30) > ''::char(30); ---- false query T SELECT ' '::char(30) < ''::char(30); ---- false query T SELECT ' '::char(30) = ' '::char(30); ---- true query T SELECT ' '::char(30) > ' '::char(30); ---- false query T SELECT ' '::char(30) < ' '::char(30); ---- false query T SELECT 'a'::char(30) = 'a'::varchar(3); ---- true query T SELECT 'a'::char(30) > 'a'::varchar(3); ---- false query T SELECT 'a'::char(30) < 'a'::varchar(3); ---- false query T SELECT 'a'::char(30) = 'a '::varchar(3); ---- true query T SELECT 'a'::char(30) > 'a '::varchar(3); ---- false query T SELECT 'a'::char(30) < 'a '::varchar(3); ---- false query T SELECT 'a'::char(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::char(30) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::char(30) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a'::char(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::char(30) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::char(30) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a'::char(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::char(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::char(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a'::char(30) = ''::varchar(3); ---- false query T SELECT 'a'::char(30) > ''::varchar(3); ---- true query T SELECT 'a'::char(30) < ''::varchar(3); ---- false query T SELECT 'a'::char(30) = ' '::varchar(3); ---- false query T SELECT 'a'::char(30) > ' '::varchar(3); ---- true query T SELECT 'a'::char(30) < ' '::varchar(3); ---- false query T SELECT 'a '::char(30) = 'a'::varchar(3); ---- true query T SELECT 'a '::char(30) > 'a'::varchar(3); ---- false query T SELECT 'a '::char(30) < 'a'::varchar(3); ---- false query T SELECT 'a '::char(30) = 'a '::varchar(3); ---- true query T SELECT 'a '::char(30) > 'a '::varchar(3); ---- false query T SELECT 'a '::char(30) < 'a '::varchar(3); ---- false query T SELECT 'a '::char(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::char(30) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::char(30) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a '::char(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::char(30) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::char(30) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a '::char(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::char(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::char(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a '::char(30) = ''::varchar(3); ---- false query T SELECT 'a '::char(30) > ''::varchar(3); ---- true query T SELECT 'a '::char(30) < ''::varchar(3); ---- false query T SELECT 'a '::char(30) = ' '::varchar(3); ---- false query T SELECT 'a '::char(30) > ' '::varchar(3); ---- true query T SELECT 'a '::char(30) < ' '::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa'::char(30) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa'::char(30) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::char(30) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa'::char(30) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::char(30) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) = ''::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) > ''::varchar(3); ---- true query T SELECT 'aaaaa'::char(30) < ''::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) = ' '::varchar(3); ---- false query T SELECT 'aaaaa'::char(30) > ' '::varchar(3); ---- true query T SELECT 'aaaaa'::char(30) < ' '::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa '::char(30) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa '::char(30) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::char(30) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa '::char(30) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::char(30) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) = ''::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) > ''::varchar(3); ---- true query T SELECT 'aaaaa '::char(30) < ''::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) = ' '::varchar(3); ---- false query T SELECT 'aaaaa '::char(30) > ' '::varchar(3); ---- true query T SELECT 'aaaaa '::char(30) < ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'a'::varchar(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'a '::varchar(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) = ''::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) > ''::varchar(3); ---- true query T SELECT 'aaaaaa'::char(30) < ''::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) = ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::char(30) > ' '::varchar(3); ---- true query T SELECT 'aaaaaa'::char(30) < ' '::varchar(3); ---- false query T SELECT ''::char(30) = 'a'::varchar(3); ---- false query T SELECT ''::char(30) > 'a'::varchar(3); ---- false query T SELECT ''::char(30) < 'a'::varchar(3); ---- true query T SELECT ''::char(30) = 'a '::varchar(3); ---- false query T SELECT ''::char(30) > 'a '::varchar(3); ---- false query T SELECT ''::char(30) < 'a '::varchar(3); ---- true query T SELECT ''::char(30) = 'aaaaa'::varchar(3); ---- false query T SELECT ''::char(30) > 'aaaaa'::varchar(3); ---- false query T SELECT ''::char(30) < 'aaaaa'::varchar(3); ---- true query T SELECT ''::char(30) = 'aaaaa '::varchar(3); ---- false query T SELECT ''::char(30) > 'aaaaa '::varchar(3); ---- false query T SELECT ''::char(30) < 'aaaaa '::varchar(3); ---- true query T SELECT ''::char(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT ''::char(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT ''::char(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT ''::char(30) = ''::varchar(3); ---- true query T SELECT ''::char(30) > ''::varchar(3); ---- false query T SELECT ''::char(30) < ''::varchar(3); ---- false query T SELECT ''::char(30) = ' '::varchar(3); ---- true query T SELECT ''::char(30) > ' '::varchar(3); ---- false query T SELECT ''::char(30) < ' '::varchar(3); ---- false query T SELECT ' '::char(30) = 'a'::varchar(3); ---- false query T SELECT ' '::char(30) > 'a'::varchar(3); ---- false query T SELECT ' '::char(30) < 'a'::varchar(3); ---- true query T SELECT ' '::char(30) = 'a '::varchar(3); ---- false query T SELECT ' '::char(30) > 'a '::varchar(3); ---- false query T SELECT ' '::char(30) < 'a '::varchar(3); ---- true query T SELECT ' '::char(30) = 'aaaaa'::varchar(3); ---- false query T SELECT ' '::char(30) > 'aaaaa'::varchar(3); ---- false query T SELECT ' '::char(30) < 'aaaaa'::varchar(3); ---- true query T SELECT ' '::char(30) = 'aaaaa '::varchar(3); ---- false query T SELECT ' '::char(30) > 'aaaaa '::varchar(3); ---- false query T SELECT ' '::char(30) < 'aaaaa '::varchar(3); ---- true query T SELECT ' '::char(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::char(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::char(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT ' '::char(30) = ''::varchar(3); ---- true query T SELECT ' '::char(30) > ''::varchar(3); ---- false query T SELECT ' '::char(30) < ''::varchar(3); ---- false query T SELECT ' '::char(30) = ' '::varchar(3); ---- true query T SELECT ' '::char(30) > ' '::varchar(3); ---- false query T SELECT ' '::char(30) < ' '::varchar(3); ---- false query T SELECT 'a'::char(30) = 'a'::varchar(30); ---- true query T SELECT 'a'::char(30) > 'a'::varchar(30); ---- false query T SELECT 'a'::char(30) < 'a'::varchar(30); ---- false query T SELECT 'a'::char(30) = 'a '::varchar(30); ---- true query T SELECT 'a'::char(30) > 'a '::varchar(30); ---- false query T SELECT 'a'::char(30) < 'a '::varchar(30); ---- false query T SELECT 'a'::char(30) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::char(30) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::char(30) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a'::char(30) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::char(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::char(30) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a'::char(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::char(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::char(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a'::char(30) = ''::varchar(30); ---- false query T SELECT 'a'::char(30) > ''::varchar(30); ---- true query T SELECT 'a'::char(30) < ''::varchar(30); ---- false query T SELECT 'a'::char(30) = ' '::varchar(30); ---- false query T SELECT 'a'::char(30) > ' '::varchar(30); ---- true query T SELECT 'a'::char(30) < ' '::varchar(30); ---- false query T SELECT 'a '::char(30) = 'a'::varchar(30); ---- true query T SELECT 'a '::char(30) > 'a'::varchar(30); ---- false query T SELECT 'a '::char(30) < 'a'::varchar(30); ---- false query T SELECT 'a '::char(30) = 'a '::varchar(30); ---- true query T SELECT 'a '::char(30) > 'a '::varchar(30); ---- false query T SELECT 'a '::char(30) < 'a '::varchar(30); ---- false query T SELECT 'a '::char(30) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::char(30) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::char(30) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a '::char(30) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::char(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::char(30) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a '::char(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::char(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::char(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a '::char(30) = ''::varchar(30); ---- false query T SELECT 'a '::char(30) > ''::varchar(30); ---- true query T SELECT 'a '::char(30) < ''::varchar(30); ---- false query T SELECT 'a '::char(30) = ' '::varchar(30); ---- false query T SELECT 'a '::char(30) > ' '::varchar(30); ---- true query T SELECT 'a '::char(30) < ' '::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa'::char(30) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa'::char(30) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::char(30) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa'::char(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::char(30) = ''::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) > ''::varchar(30); ---- true query T SELECT 'aaaaa'::char(30) < ''::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) = ' '::varchar(30); ---- false query T SELECT 'aaaaa'::char(30) > ' '::varchar(30); ---- true query T SELECT 'aaaaa'::char(30) < ' '::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa '::char(30) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa '::char(30) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::char(30) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa '::char(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::char(30) = ''::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) > ''::varchar(30); ---- true query T SELECT 'aaaaa '::char(30) < ''::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) = ' '::varchar(30); ---- false query T SELECT 'aaaaa '::char(30) > ' '::varchar(30); ---- true query T SELECT 'aaaaa '::char(30) < ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'a'::varchar(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'a '::varchar(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::char(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) < 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) = ''::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) > ''::varchar(30); ---- true query T SELECT 'aaaaaa'::char(30) < ''::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) = ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::char(30) > ' '::varchar(30); ---- true query T SELECT 'aaaaaa'::char(30) < ' '::varchar(30); ---- false query T SELECT ''::char(30) = 'a'::varchar(30); ---- false query T SELECT ''::char(30) > 'a'::varchar(30); ---- false query T SELECT ''::char(30) < 'a'::varchar(30); ---- true query T SELECT ''::char(30) = 'a '::varchar(30); ---- false query T SELECT ''::char(30) > 'a '::varchar(30); ---- false query T SELECT ''::char(30) < 'a '::varchar(30); ---- true query T SELECT ''::char(30) = 'aaaaa'::varchar(30); ---- false query T SELECT ''::char(30) > 'aaaaa'::varchar(30); ---- false query T SELECT ''::char(30) < 'aaaaa'::varchar(30); ---- true query T SELECT ''::char(30) = 'aaaaa '::varchar(30); ---- false query T SELECT ''::char(30) > 'aaaaa '::varchar(30); ---- false query T SELECT ''::char(30) < 'aaaaa '::varchar(30); ---- true query T SELECT ''::char(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT ''::char(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT ''::char(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT ''::char(30) = ''::varchar(30); ---- true query T SELECT ''::char(30) > ''::varchar(30); ---- false query T SELECT ''::char(30) < ''::varchar(30); ---- false query T SELECT ''::char(30) = ' '::varchar(30); ---- true query T SELECT ''::char(30) > ' '::varchar(30); ---- false query T SELECT ''::char(30) < ' '::varchar(30); ---- false query T SELECT ' '::char(30) = 'a'::varchar(30); ---- false query T SELECT ' '::char(30) > 'a'::varchar(30); ---- false query T SELECT ' '::char(30) < 'a'::varchar(30); ---- true query T SELECT ' '::char(30) = 'a '::varchar(30); ---- false query T SELECT ' '::char(30) > 'a '::varchar(30); ---- false query T SELECT ' '::char(30) < 'a '::varchar(30); ---- true query T SELECT ' '::char(30) = 'aaaaa'::varchar(30); ---- false query T SELECT ' '::char(30) > 'aaaaa'::varchar(30); ---- false query T SELECT ' '::char(30) < 'aaaaa'::varchar(30); ---- true query T SELECT ' '::char(30) = 'aaaaa '::varchar(30); ---- false query T SELECT ' '::char(30) > 'aaaaa '::varchar(30); ---- false query T SELECT ' '::char(30) < 'aaaaa '::varchar(30); ---- true query T SELECT ' '::char(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::char(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::char(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT ' '::char(30) = ''::varchar(30); ---- true query T SELECT ' '::char(30) > ''::varchar(30); ---- false query T SELECT ' '::char(30) < ''::varchar(30); ---- false query T SELECT ' '::char(30) = ' '::varchar(30); ---- true query T SELECT ' '::char(30) > ' '::varchar(30); ---- false query T SELECT ' '::char(30) < ' '::varchar(30); ---- false query T SELECT 'a'::char(30) = 'a'::text; ---- true query T SELECT 'a'::char(30) > 'a'::text; ---- false query T SELECT 'a'::char(30) < 'a'::text; ---- false query T SELECT 'a'::char(30) = 'a '::text; ---- false query T SELECT 'a'::char(30) > 'a '::text; ---- false query T SELECT 'a'::char(30) < 'a '::text; ---- true query T SELECT 'a'::char(30) = 'aaaaa'::text; ---- false query T SELECT 'a'::char(30) > 'aaaaa'::text; ---- false query T SELECT 'a'::char(30) < 'aaaaa'::text; ---- true query T SELECT 'a'::char(30) = 'aaaaa '::text; ---- false query T SELECT 'a'::char(30) > 'aaaaa '::text; ---- false query T SELECT 'a'::char(30) < 'aaaaa '::text; ---- true query T SELECT 'a'::char(30) = 'aaaaaa'::text; ---- false query T SELECT 'a'::char(30) > 'aaaaaa'::text; ---- false query T SELECT 'a'::char(30) < 'aaaaaa'::text; ---- true query T SELECT 'a'::char(30) = ''::text; ---- false query T SELECT 'a'::char(30) > ''::text; ---- true query T SELECT 'a'::char(30) < ''::text; ---- false query T SELECT 'a'::char(30) = ' '::text; ---- false query T SELECT 'a'::char(30) > ' '::text; ---- true query T SELECT 'a'::char(30) < ' '::text; ---- false query T SELECT 'a '::char(30) = 'a'::text; ---- true query T SELECT 'a '::char(30) > 'a'::text; ---- false query T SELECT 'a '::char(30) < 'a'::text; ---- false query T SELECT 'a '::char(30) = 'a '::text; ---- false query T SELECT 'a '::char(30) > 'a '::text; ---- false query T SELECT 'a '::char(30) < 'a '::text; ---- true query T SELECT 'a '::char(30) = 'aaaaa'::text; ---- false query T SELECT 'a '::char(30) > 'aaaaa'::text; ---- false query T SELECT 'a '::char(30) < 'aaaaa'::text; ---- true query T SELECT 'a '::char(30) = 'aaaaa '::text; ---- false query T SELECT 'a '::char(30) > 'aaaaa '::text; ---- false query T SELECT 'a '::char(30) < 'aaaaa '::text; ---- true query T SELECT 'a '::char(30) = 'aaaaaa'::text; ---- false query T SELECT 'a '::char(30) > 'aaaaaa'::text; ---- false query T SELECT 'a '::char(30) < 'aaaaaa'::text; ---- true query T SELECT 'a '::char(30) = ''::text; ---- false query T SELECT 'a '::char(30) > ''::text; ---- true query T SELECT 'a '::char(30) < ''::text; ---- false query T SELECT 'a '::char(30) = ' '::text; ---- false query T SELECT 'a '::char(30) > ' '::text; ---- true query T SELECT 'a '::char(30) < ' '::text; ---- false query T SELECT 'aaaaa'::char(30) = 'a'::text; ---- false query T SELECT 'aaaaa'::char(30) > 'a'::text; ---- true query T SELECT 'aaaaa'::char(30) < 'a'::text; ---- false query T SELECT 'aaaaa'::char(30) = 'a '::text; ---- false query T SELECT 'aaaaa'::char(30) > 'a '::text; ---- true query T SELECT 'aaaaa'::char(30) < 'a '::text; ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa'::text; ---- true query T SELECT 'aaaaa'::char(30) > 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::char(30) = 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaa '::text; ---- true query T SELECT 'aaaaa'::char(30) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::char(30) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::char(30) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa'::char(30) = ''::text; ---- false query T SELECT 'aaaaa'::char(30) > ''::text; ---- true query T SELECT 'aaaaa'::char(30) < ''::text; ---- false query T SELECT 'aaaaa'::char(30) = ' '::text; ---- false query T SELECT 'aaaaa'::char(30) > ' '::text; ---- true query T SELECT 'aaaaa'::char(30) < ' '::text; ---- false query T SELECT 'aaaaa '::char(30) = 'a'::text; ---- false query T SELECT 'aaaaa '::char(30) > 'a'::text; ---- true query T SELECT 'aaaaa '::char(30) < 'a'::text; ---- false query T SELECT 'aaaaa '::char(30) = 'a '::text; ---- false query T SELECT 'aaaaa '::char(30) > 'a '::text; ---- true query T SELECT 'aaaaa '::char(30) < 'a '::text; ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa'::text; ---- true query T SELECT 'aaaaa '::char(30) > 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::char(30) = 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaa '::text; ---- true query T SELECT 'aaaaa '::char(30) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::char(30) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::char(30) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa '::char(30) = ''::text; ---- false query T SELECT 'aaaaa '::char(30) > ''::text; ---- true query T SELECT 'aaaaa '::char(30) < ''::text; ---- false query T SELECT 'aaaaa '::char(30) = ' '::text; ---- false query T SELECT 'aaaaa '::char(30) > ' '::text; ---- true query T SELECT 'aaaaa '::char(30) < ' '::text; ---- false query T SELECT 'aaaaaa'::char(30) = 'a'::text; ---- false query T SELECT 'aaaaaa'::char(30) > 'a'::text; ---- true query T SELECT 'aaaaaa'::char(30) < 'a'::text; ---- false query T SELECT 'aaaaaa'::char(30) = 'a '::text; ---- false query T SELECT 'aaaaaa'::char(30) > 'a '::text; ---- true query T SELECT 'aaaaaa'::char(30) < 'a '::text; ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa'::text; ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::char(30) > 'aaaaa '::text; ---- true query T SELECT 'aaaaaa'::char(30) < 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::char(30) = 'aaaaaa'::text; ---- true query T SELECT 'aaaaaa'::char(30) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(30) < 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::char(30) = ''::text; ---- false query T SELECT 'aaaaaa'::char(30) > ''::text; ---- true query T SELECT 'aaaaaa'::char(30) < ''::text; ---- false query T SELECT 'aaaaaa'::char(30) = ' '::text; ---- false query T SELECT 'aaaaaa'::char(30) > ' '::text; ---- true query T SELECT 'aaaaaa'::char(30) < ' '::text; ---- false query T SELECT ''::char(30) = 'a'::text; ---- false query T SELECT ''::char(30) > 'a'::text; ---- false query T SELECT ''::char(30) < 'a'::text; ---- true query T SELECT ''::char(30) = 'a '::text; ---- false query T SELECT ''::char(30) > 'a '::text; ---- false query T SELECT ''::char(30) < 'a '::text; ---- true query T SELECT ''::char(30) = 'aaaaa'::text; ---- false query T SELECT ''::char(30) > 'aaaaa'::text; ---- false query T SELECT ''::char(30) < 'aaaaa'::text; ---- true query T SELECT ''::char(30) = 'aaaaa '::text; ---- false query T SELECT ''::char(30) > 'aaaaa '::text; ---- false query T SELECT ''::char(30) < 'aaaaa '::text; ---- true query T SELECT ''::char(30) = 'aaaaaa'::text; ---- false query T SELECT ''::char(30) > 'aaaaaa'::text; ---- false query T SELECT ''::char(30) < 'aaaaaa'::text; ---- true query T SELECT ''::char(30) = ''::text; ---- true query T SELECT ''::char(30) > ''::text; ---- false query T SELECT ''::char(30) < ''::text; ---- false query T SELECT ''::char(30) = ' '::text; ---- false query T SELECT ''::char(30) > ' '::text; ---- false query T SELECT ''::char(30) < ' '::text; ---- true query T SELECT ' '::char(30) = 'a'::text; ---- false query T SELECT ' '::char(30) > 'a'::text; ---- false query T SELECT ' '::char(30) < 'a'::text; ---- true query T SELECT ' '::char(30) = 'a '::text; ---- false query T SELECT ' '::char(30) > 'a '::text; ---- false query T SELECT ' '::char(30) < 'a '::text; ---- true query T SELECT ' '::char(30) = 'aaaaa'::text; ---- false query T SELECT ' '::char(30) > 'aaaaa'::text; ---- false query T SELECT ' '::char(30) < 'aaaaa'::text; ---- true query T SELECT ' '::char(30) = 'aaaaa '::text; ---- false query T SELECT ' '::char(30) > 'aaaaa '::text; ---- false query T SELECT ' '::char(30) < 'aaaaa '::text; ---- true query T SELECT ' '::char(30) = 'aaaaaa'::text; ---- false query T SELECT ' '::char(30) > 'aaaaaa'::text; ---- false query T SELECT ' '::char(30) < 'aaaaaa'::text; ---- true query T SELECT ' '::char(30) = ''::text; ---- true query T SELECT ' '::char(30) > ''::text; ---- false query T SELECT ' '::char(30) < ''::text; ---- false query T SELECT ' '::char(30) = ' '::text; ---- false query T SELECT ' '::char(30) > ' '::text; ---- false query T SELECT ' '::char(30) < ' '::text; ---- true query T SELECT 'a'::varchar(3) = 'a'::char(3); ---- true query T SELECT 'a'::varchar(3) > 'a'::char(3); ---- false query T SELECT 'a'::varchar(3) < 'a'::char(3); ---- false query T SELECT 'a'::varchar(3) = 'a '::char(3); ---- true query T SELECT 'a'::varchar(3) > 'a '::char(3); ---- false query T SELECT 'a'::varchar(3) < 'a '::char(3); ---- false query T SELECT 'a'::varchar(3) = 'aaaaa'::char(3); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa'::char(3); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa'::char(3); ---- true query T SELECT 'a'::varchar(3) = 'aaaaa '::char(3); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa '::char(3); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa '::char(3); ---- true query T SELECT 'a'::varchar(3) = 'aaaaaa'::char(3); ---- false query T SELECT 'a'::varchar(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'a'::varchar(3) < 'aaaaaa'::char(3); ---- true query T SELECT 'a'::varchar(3) = ''::char(3); ---- false query T SELECT 'a'::varchar(3) > ''::char(3); ---- true query T SELECT 'a'::varchar(3) < ''::char(3); ---- false query T SELECT 'a'::varchar(3) = ' '::char(3); ---- false query T SELECT 'a'::varchar(3) > ' '::char(3); ---- true query T SELECT 'a'::varchar(3) < ' '::char(3); ---- false query T SELECT 'a '::varchar(3) = 'a'::char(3); ---- true query T SELECT 'a '::varchar(3) > 'a'::char(3); ---- false query T SELECT 'a '::varchar(3) < 'a'::char(3); ---- false query T SELECT 'a '::varchar(3) = 'a '::char(3); ---- true query T SELECT 'a '::varchar(3) > 'a '::char(3); ---- false query T SELECT 'a '::varchar(3) < 'a '::char(3); ---- false query T SELECT 'a '::varchar(3) = 'aaaaa'::char(3); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa'::char(3); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa'::char(3); ---- true query T SELECT 'a '::varchar(3) = 'aaaaa '::char(3); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa '::char(3); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa '::char(3); ---- true query T SELECT 'a '::varchar(3) = 'aaaaaa'::char(3); ---- false query T SELECT 'a '::varchar(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'a '::varchar(3) < 'aaaaaa'::char(3); ---- true query T SELECT 'a '::varchar(3) = ''::char(3); ---- false query T SELECT 'a '::varchar(3) > ''::char(3); ---- true query T SELECT 'a '::varchar(3) < ''::char(3); ---- false query T SELECT 'a '::varchar(3) = ' '::char(3); ---- false query T SELECT 'a '::varchar(3) > ' '::char(3); ---- true query T SELECT 'a '::varchar(3) < ' '::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a'::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a'::char(3); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a'::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a '::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a '::char(3); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a '::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa'::varchar(3) > 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa'::varchar(3) > 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa'::varchar(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) = ''::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) > ''::char(3); ---- true query T SELECT 'aaaaa'::varchar(3) < ''::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) = ' '::char(3); ---- false query T SELECT 'aaaaa'::varchar(3) > ' '::char(3); ---- true query T SELECT 'aaaaa'::varchar(3) < ' '::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a'::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a'::char(3); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a'::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a '::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a '::char(3); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a '::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa '::varchar(3) > 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa '::varchar(3) > 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa '::varchar(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) = ''::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) > ''::char(3); ---- true query T SELECT 'aaaaa '::varchar(3) < ''::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) = ' '::char(3); ---- false query T SELECT 'aaaaa '::varchar(3) > ' '::char(3); ---- true query T SELECT 'aaaaa '::varchar(3) < ' '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a'::char(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a '::char(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa '::char(3); ---- true query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::varchar(3) > 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = ''::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > ''::char(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < ''::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = ' '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > ' '::char(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < ' '::char(3); ---- false query T SELECT ''::varchar(3) = 'a'::char(3); ---- false query T SELECT ''::varchar(3) > 'a'::char(3); ---- false query T SELECT ''::varchar(3) < 'a'::char(3); ---- true query T SELECT ''::varchar(3) = 'a '::char(3); ---- false query T SELECT ''::varchar(3) > 'a '::char(3); ---- false query T SELECT ''::varchar(3) < 'a '::char(3); ---- true query T SELECT ''::varchar(3) = 'aaaaa'::char(3); ---- false query T SELECT ''::varchar(3) > 'aaaaa'::char(3); ---- false query T SELECT ''::varchar(3) < 'aaaaa'::char(3); ---- true query T SELECT ''::varchar(3) = 'aaaaa '::char(3); ---- false query T SELECT ''::varchar(3) > 'aaaaa '::char(3); ---- false query T SELECT ''::varchar(3) < 'aaaaa '::char(3); ---- true query T SELECT ''::varchar(3) = 'aaaaaa'::char(3); ---- false query T SELECT ''::varchar(3) > 'aaaaaa'::char(3); ---- false query T SELECT ''::varchar(3) < 'aaaaaa'::char(3); ---- true query T SELECT ''::varchar(3) = ''::char(3); ---- true query T SELECT ''::varchar(3) > ''::char(3); ---- false query T SELECT ''::varchar(3) < ''::char(3); ---- false query T SELECT ''::varchar(3) = ' '::char(3); ---- true query T SELECT ''::varchar(3) > ' '::char(3); ---- false query T SELECT ''::varchar(3) < ' '::char(3); ---- false query T SELECT ' '::varchar(3) = 'a'::char(3); ---- false query T SELECT ' '::varchar(3) > 'a'::char(3); ---- false query T SELECT ' '::varchar(3) < 'a'::char(3); ---- true query T SELECT ' '::varchar(3) = 'a '::char(3); ---- false query T SELECT ' '::varchar(3) > 'a '::char(3); ---- false query T SELECT ' '::varchar(3) < 'a '::char(3); ---- true query T SELECT ' '::varchar(3) = 'aaaaa'::char(3); ---- false query T SELECT ' '::varchar(3) > 'aaaaa'::char(3); ---- false query T SELECT ' '::varchar(3) < 'aaaaa'::char(3); ---- true query T SELECT ' '::varchar(3) = 'aaaaa '::char(3); ---- false query T SELECT ' '::varchar(3) > 'aaaaa '::char(3); ---- false query T SELECT ' '::varchar(3) < 'aaaaa '::char(3); ---- true query T SELECT ' '::varchar(3) = 'aaaaaa'::char(3); ---- false query T SELECT ' '::varchar(3) > 'aaaaaa'::char(3); ---- false query T SELECT ' '::varchar(3) < 'aaaaaa'::char(3); ---- true query T SELECT ' '::varchar(3) = ''::char(3); ---- true query T SELECT ' '::varchar(3) > ''::char(3); ---- false query T SELECT ' '::varchar(3) < ''::char(3); ---- false query T SELECT ' '::varchar(3) = ' '::char(3); ---- true query T SELECT ' '::varchar(3) > ' '::char(3); ---- false query T SELECT ' '::varchar(3) < ' '::char(3); ---- false query T SELECT 'a'::varchar(3) = 'a'::char(30); ---- true query T SELECT 'a'::varchar(3) > 'a'::char(30); ---- false query T SELECT 'a'::varchar(3) < 'a'::char(30); ---- false query T SELECT 'a'::varchar(3) = 'a '::char(30); ---- true query T SELECT 'a'::varchar(3) > 'a '::char(30); ---- false query T SELECT 'a'::varchar(3) < 'a '::char(30); ---- false query T SELECT 'a'::varchar(3) = 'aaaaa'::char(30); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa'::char(30); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa'::char(30); ---- true query T SELECT 'a'::varchar(3) = 'aaaaa '::char(30); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa '::char(30); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa '::char(30); ---- true query T SELECT 'a'::varchar(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'a'::varchar(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'a'::varchar(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'a'::varchar(3) = ''::char(30); ---- false query T SELECT 'a'::varchar(3) > ''::char(30); ---- true query T SELECT 'a'::varchar(3) < ''::char(30); ---- false query T SELECT 'a'::varchar(3) = ' '::char(30); ---- false query T SELECT 'a'::varchar(3) > ' '::char(30); ---- true query T SELECT 'a'::varchar(3) < ' '::char(30); ---- false query T SELECT 'a '::varchar(3) = 'a'::char(30); ---- true query T SELECT 'a '::varchar(3) > 'a'::char(30); ---- false query T SELECT 'a '::varchar(3) < 'a'::char(30); ---- false query T SELECT 'a '::varchar(3) = 'a '::char(30); ---- true query T SELECT 'a '::varchar(3) > 'a '::char(30); ---- false query T SELECT 'a '::varchar(3) < 'a '::char(30); ---- false query T SELECT 'a '::varchar(3) = 'aaaaa'::char(30); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa'::char(30); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa'::char(30); ---- true query T SELECT 'a '::varchar(3) = 'aaaaa '::char(30); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa '::char(30); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa '::char(30); ---- true query T SELECT 'a '::varchar(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'a '::varchar(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'a '::varchar(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'a '::varchar(3) = ''::char(30); ---- false query T SELECT 'a '::varchar(3) > ''::char(30); ---- true query T SELECT 'a '::varchar(3) < ''::char(30); ---- false query T SELECT 'a '::varchar(3) = ' '::char(30); ---- false query T SELECT 'a '::varchar(3) > ' '::char(30); ---- true query T SELECT 'a '::varchar(3) < ' '::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a'::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a'::char(30); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a'::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a '::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a '::char(30); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a '::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa'::varchar(3) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa'::varchar(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa'::varchar(3) = ''::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) > ''::char(30); ---- true query T SELECT 'aaaaa'::varchar(3) < ''::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) = ' '::char(30); ---- false query T SELECT 'aaaaa'::varchar(3) > ' '::char(30); ---- true query T SELECT 'aaaaa'::varchar(3) < ' '::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a'::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a'::char(30); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a'::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a '::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a '::char(30); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a '::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa '::varchar(3) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa '::varchar(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa '::varchar(3) = ''::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) > ''::char(30); ---- true query T SELECT 'aaaaa '::varchar(3) < ''::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) = ' '::char(30); ---- false query T SELECT 'aaaaa '::varchar(3) > ' '::char(30); ---- true query T SELECT 'aaaaa '::varchar(3) < ' '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a'::char(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a '::char(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa '::char(30); ---- true query T SELECT 'aaaaaa'::varchar(3) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::varchar(3) = ''::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > ''::char(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < ''::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = ' '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > ' '::char(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < ' '::char(30); ---- false query T SELECT ''::varchar(3) = 'a'::char(30); ---- false query T SELECT ''::varchar(3) > 'a'::char(30); ---- false query T SELECT ''::varchar(3) < 'a'::char(30); ---- true query T SELECT ''::varchar(3) = 'a '::char(30); ---- false query T SELECT ''::varchar(3) > 'a '::char(30); ---- false query T SELECT ''::varchar(3) < 'a '::char(30); ---- true query T SELECT ''::varchar(3) = 'aaaaa'::char(30); ---- false query T SELECT ''::varchar(3) > 'aaaaa'::char(30); ---- false query T SELECT ''::varchar(3) < 'aaaaa'::char(30); ---- true query T SELECT ''::varchar(3) = 'aaaaa '::char(30); ---- false query T SELECT ''::varchar(3) > 'aaaaa '::char(30); ---- false query T SELECT ''::varchar(3) < 'aaaaa '::char(30); ---- true query T SELECT ''::varchar(3) = 'aaaaaa'::char(30); ---- false query T SELECT ''::varchar(3) > 'aaaaaa'::char(30); ---- false query T SELECT ''::varchar(3) < 'aaaaaa'::char(30); ---- true query T SELECT ''::varchar(3) = ''::char(30); ---- true query T SELECT ''::varchar(3) > ''::char(30); ---- false query T SELECT ''::varchar(3) < ''::char(30); ---- false query T SELECT ''::varchar(3) = ' '::char(30); ---- true query T SELECT ''::varchar(3) > ' '::char(30); ---- false query T SELECT ''::varchar(3) < ' '::char(30); ---- false query T SELECT ' '::varchar(3) = 'a'::char(30); ---- false query T SELECT ' '::varchar(3) > 'a'::char(30); ---- false query T SELECT ' '::varchar(3) < 'a'::char(30); ---- true query T SELECT ' '::varchar(3) = 'a '::char(30); ---- false query T SELECT ' '::varchar(3) > 'a '::char(30); ---- false query T SELECT ' '::varchar(3) < 'a '::char(30); ---- true query T SELECT ' '::varchar(3) = 'aaaaa'::char(30); ---- false query T SELECT ' '::varchar(3) > 'aaaaa'::char(30); ---- false query T SELECT ' '::varchar(3) < 'aaaaa'::char(30); ---- true query T SELECT ' '::varchar(3) = 'aaaaa '::char(30); ---- false query T SELECT ' '::varchar(3) > 'aaaaa '::char(30); ---- false query T SELECT ' '::varchar(3) < 'aaaaa '::char(30); ---- true query T SELECT ' '::varchar(3) = 'aaaaaa'::char(30); ---- false query T SELECT ' '::varchar(3) > 'aaaaaa'::char(30); ---- false query T SELECT ' '::varchar(3) < 'aaaaaa'::char(30); ---- true query T SELECT ' '::varchar(3) = ''::char(30); ---- true query T SELECT ' '::varchar(3) > ''::char(30); ---- false query T SELECT ' '::varchar(3) < ''::char(30); ---- false query T SELECT ' '::varchar(3) = ' '::char(30); ---- true query T SELECT ' '::varchar(3) > ' '::char(30); ---- false query T SELECT ' '::varchar(3) < ' '::char(30); ---- false query T SELECT 'a'::varchar(3) = 'a'::varchar(3); ---- true query T SELECT 'a'::varchar(3) > 'a'::varchar(3); ---- false query T SELECT 'a'::varchar(3) < 'a'::varchar(3); ---- false query T SELECT 'a'::varchar(3) = 'a '::varchar(3); ---- false query T SELECT 'a'::varchar(3) > 'a '::varchar(3); ---- false query T SELECT 'a'::varchar(3) < 'a '::varchar(3); ---- true query T SELECT 'a'::varchar(3) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a'::varchar(3) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a'::varchar(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a'::varchar(3) = ''::varchar(3); ---- false query T SELECT 'a'::varchar(3) > ''::varchar(3); ---- true query T SELECT 'a'::varchar(3) < ''::varchar(3); ---- false query T SELECT 'a'::varchar(3) = ' '::varchar(3); ---- false query T SELECT 'a'::varchar(3) > ' '::varchar(3); ---- true query T SELECT 'a'::varchar(3) < ' '::varchar(3); ---- false query T SELECT 'a '::varchar(3) = 'a'::varchar(3); ---- false query T SELECT 'a '::varchar(3) > 'a'::varchar(3); ---- true query T SELECT 'a '::varchar(3) < 'a'::varchar(3); ---- false query T SELECT 'a '::varchar(3) = 'a '::varchar(3); ---- true query T SELECT 'a '::varchar(3) > 'a '::varchar(3); ---- false query T SELECT 'a '::varchar(3) < 'a '::varchar(3); ---- false query T SELECT 'a '::varchar(3) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a '::varchar(3) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a '::varchar(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a '::varchar(3) = ''::varchar(3); ---- false query T SELECT 'a '::varchar(3) > ''::varchar(3); ---- true query T SELECT 'a '::varchar(3) < ''::varchar(3); ---- false query T SELECT 'a '::varchar(3) = ' '::varchar(3); ---- false query T SELECT 'a '::varchar(3) > ' '::varchar(3); ---- true query T SELECT 'a '::varchar(3) < ' '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) = ''::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) > ''::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(3) < ''::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) = ' '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(3) > ' '::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(3) < ' '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) = ''::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) > ''::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(3) < ''::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) = ' '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(3) > ' '::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(3) < ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a'::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a '::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = ''::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > ''::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < ''::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) = ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(3) > ' '::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(3) < ' '::varchar(3); ---- false query T SELECT ''::varchar(3) = 'a'::varchar(3); ---- false query T SELECT ''::varchar(3) > 'a'::varchar(3); ---- false query T SELECT ''::varchar(3) < 'a'::varchar(3); ---- true query T SELECT ''::varchar(3) = 'a '::varchar(3); ---- false query T SELECT ''::varchar(3) > 'a '::varchar(3); ---- false query T SELECT ''::varchar(3) < 'a '::varchar(3); ---- true query T SELECT ''::varchar(3) = 'aaaaa'::varchar(3); ---- false query T SELECT ''::varchar(3) > 'aaaaa'::varchar(3); ---- false query T SELECT ''::varchar(3) < 'aaaaa'::varchar(3); ---- true query T SELECT ''::varchar(3) = 'aaaaa '::varchar(3); ---- false query T SELECT ''::varchar(3) > 'aaaaa '::varchar(3); ---- false query T SELECT ''::varchar(3) < 'aaaaa '::varchar(3); ---- true query T SELECT ''::varchar(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT ''::varchar(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT ''::varchar(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT ''::varchar(3) = ''::varchar(3); ---- true query T SELECT ''::varchar(3) > ''::varchar(3); ---- false query T SELECT ''::varchar(3) < ''::varchar(3); ---- false query T SELECT ''::varchar(3) = ' '::varchar(3); ---- false query T SELECT ''::varchar(3) > ' '::varchar(3); ---- false query T SELECT ''::varchar(3) < ' '::varchar(3); ---- true query T SELECT ' '::varchar(3) = 'a'::varchar(3); ---- false query T SELECT ' '::varchar(3) > 'a'::varchar(3); ---- false query T SELECT ' '::varchar(3) < 'a'::varchar(3); ---- true query T SELECT ' '::varchar(3) = 'a '::varchar(3); ---- false query T SELECT ' '::varchar(3) > 'a '::varchar(3); ---- false query T SELECT ' '::varchar(3) < 'a '::varchar(3); ---- true query T SELECT ' '::varchar(3) = 'aaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(3) > 'aaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(3) < 'aaaaa'::varchar(3); ---- true query T SELECT ' '::varchar(3) = 'aaaaa '::varchar(3); ---- false query T SELECT ' '::varchar(3) > 'aaaaa '::varchar(3); ---- false query T SELECT ' '::varchar(3) < 'aaaaa '::varchar(3); ---- true query T SELECT ' '::varchar(3) = 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(3) > 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(3) < 'aaaaaa'::varchar(3); ---- true query T SELECT ' '::varchar(3) = ''::varchar(3); ---- false query T SELECT ' '::varchar(3) > ''::varchar(3); ---- true query T SELECT ' '::varchar(3) < ''::varchar(3); ---- false query T SELECT ' '::varchar(3) = ' '::varchar(3); ---- true query T SELECT ' '::varchar(3) > ' '::varchar(3); ---- false query T SELECT ' '::varchar(3) < ' '::varchar(3); ---- false query T SELECT 'a'::varchar(3) = 'a'::varchar(30); ---- true query T SELECT 'a'::varchar(3) > 'a'::varchar(30); ---- false query T SELECT 'a'::varchar(3) < 'a'::varchar(30); ---- false query T SELECT 'a'::varchar(3) = 'a '::varchar(30); ---- false query T SELECT 'a'::varchar(3) > 'a '::varchar(30); ---- false query T SELECT 'a'::varchar(3) < 'a '::varchar(30); ---- true query T SELECT 'a'::varchar(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a'::varchar(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::varchar(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::varchar(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a'::varchar(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a'::varchar(3) = ''::varchar(30); ---- false query T SELECT 'a'::varchar(3) > ''::varchar(30); ---- true query T SELECT 'a'::varchar(3) < ''::varchar(30); ---- false query T SELECT 'a'::varchar(3) = ' '::varchar(30); ---- false query T SELECT 'a'::varchar(3) > ' '::varchar(30); ---- true query T SELECT 'a'::varchar(3) < ' '::varchar(30); ---- false query T SELECT 'a '::varchar(3) = 'a'::varchar(30); ---- false query T SELECT 'a '::varchar(3) > 'a'::varchar(30); ---- true query T SELECT 'a '::varchar(3) < 'a'::varchar(30); ---- false query T SELECT 'a '::varchar(3) = 'a '::varchar(30); ---- true query T SELECT 'a '::varchar(3) > 'a '::varchar(30); ---- false query T SELECT 'a '::varchar(3) < 'a '::varchar(30); ---- false query T SELECT 'a '::varchar(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a '::varchar(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::varchar(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::varchar(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a '::varchar(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a '::varchar(3) = ''::varchar(30); ---- false query T SELECT 'a '::varchar(3) > ''::varchar(30); ---- true query T SELECT 'a '::varchar(3) < ''::varchar(30); ---- false query T SELECT 'a '::varchar(3) = ' '::varchar(30); ---- false query T SELECT 'a '::varchar(3) > ' '::varchar(30); ---- true query T SELECT 'a '::varchar(3) < ' '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(3) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(3) = ''::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) > ''::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(3) < ''::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) = ' '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(3) > ' '::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(3) < ' '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(3) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(3) = ''::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) > ''::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(3) < ''::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) = ' '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(3) > ' '::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(3) < ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a'::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a '::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(3) = ''::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > ''::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < ''::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) = ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(3) > ' '::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(3) < ' '::varchar(30); ---- false query T SELECT ''::varchar(3) = 'a'::varchar(30); ---- false query T SELECT ''::varchar(3) > 'a'::varchar(30); ---- false query T SELECT ''::varchar(3) < 'a'::varchar(30); ---- true query T SELECT ''::varchar(3) = 'a '::varchar(30); ---- false query T SELECT ''::varchar(3) > 'a '::varchar(30); ---- false query T SELECT ''::varchar(3) < 'a '::varchar(30); ---- true query T SELECT ''::varchar(3) = 'aaaaa'::varchar(30); ---- false query T SELECT ''::varchar(3) > 'aaaaa'::varchar(30); ---- false query T SELECT ''::varchar(3) < 'aaaaa'::varchar(30); ---- true query T SELECT ''::varchar(3) = 'aaaaa '::varchar(30); ---- false query T SELECT ''::varchar(3) > 'aaaaa '::varchar(30); ---- false query T SELECT ''::varchar(3) < 'aaaaa '::varchar(30); ---- true query T SELECT ''::varchar(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT ''::varchar(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT ''::varchar(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT ''::varchar(3) = ''::varchar(30); ---- true query T SELECT ''::varchar(3) > ''::varchar(30); ---- false query T SELECT ''::varchar(3) < ''::varchar(30); ---- false query T SELECT ''::varchar(3) = ' '::varchar(30); ---- false query T SELECT ''::varchar(3) > ' '::varchar(30); ---- false query T SELECT ''::varchar(3) < ' '::varchar(30); ---- true query T SELECT ' '::varchar(3) = 'a'::varchar(30); ---- false query T SELECT ' '::varchar(3) > 'a'::varchar(30); ---- false query T SELECT ' '::varchar(3) < 'a'::varchar(30); ---- true query T SELECT ' '::varchar(3) = 'a '::varchar(30); ---- false query T SELECT ' '::varchar(3) > 'a '::varchar(30); ---- false query T SELECT ' '::varchar(3) < 'a '::varchar(30); ---- true query T SELECT ' '::varchar(3) = 'aaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(3) > 'aaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(3) < 'aaaaa'::varchar(30); ---- true query T SELECT ' '::varchar(3) = 'aaaaa '::varchar(30); ---- false query T SELECT ' '::varchar(3) > 'aaaaa '::varchar(30); ---- false query T SELECT ' '::varchar(3) < 'aaaaa '::varchar(30); ---- true query T SELECT ' '::varchar(3) = 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(3) > 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(3) < 'aaaaaa'::varchar(30); ---- true query T SELECT ' '::varchar(3) = ''::varchar(30); ---- false query T SELECT ' '::varchar(3) > ''::varchar(30); ---- true query T SELECT ' '::varchar(3) < ''::varchar(30); ---- false query T SELECT ' '::varchar(3) = ' '::varchar(30); ---- true query T SELECT ' '::varchar(3) > ' '::varchar(30); ---- false query T SELECT ' '::varchar(3) < ' '::varchar(30); ---- false query T SELECT 'a'::varchar(3) = 'a'::text; ---- true query T SELECT 'a'::varchar(3) > 'a'::text; ---- false query T SELECT 'a'::varchar(3) < 'a'::text; ---- false query T SELECT 'a'::varchar(3) = 'a '::text; ---- false query T SELECT 'a'::varchar(3) > 'a '::text; ---- false query T SELECT 'a'::varchar(3) < 'a '::text; ---- true query T SELECT 'a'::varchar(3) = 'aaaaa'::text; ---- false query T SELECT 'a'::varchar(3) > 'aaaaa'::text; ---- false query T SELECT 'a'::varchar(3) < 'aaaaa'::text; ---- true query T SELECT 'a'::varchar(3) = 'aaaaa '::text; ---- false query T SELECT 'a'::varchar(3) > 'aaaaa '::text; ---- false query T SELECT 'a'::varchar(3) < 'aaaaa '::text; ---- true query T SELECT 'a'::varchar(3) = 'aaaaaa'::text; ---- false query T SELECT 'a'::varchar(3) > 'aaaaaa'::text; ---- false query T SELECT 'a'::varchar(3) < 'aaaaaa'::text; ---- true query T SELECT 'a'::varchar(3) = ''::text; ---- false query T SELECT 'a'::varchar(3) > ''::text; ---- true query T SELECT 'a'::varchar(3) < ''::text; ---- false query T SELECT 'a'::varchar(3) = ' '::text; ---- false query T SELECT 'a'::varchar(3) > ' '::text; ---- true query T SELECT 'a'::varchar(3) < ' '::text; ---- false query T SELECT 'a '::varchar(3) = 'a'::text; ---- false query T SELECT 'a '::varchar(3) > 'a'::text; ---- true query T SELECT 'a '::varchar(3) < 'a'::text; ---- false query T SELECT 'a '::varchar(3) = 'a '::text; ---- true query T SELECT 'a '::varchar(3) > 'a '::text; ---- false query T SELECT 'a '::varchar(3) < 'a '::text; ---- false query T SELECT 'a '::varchar(3) = 'aaaaa'::text; ---- false query T SELECT 'a '::varchar(3) > 'aaaaa'::text; ---- false query T SELECT 'a '::varchar(3) < 'aaaaa'::text; ---- true query T SELECT 'a '::varchar(3) = 'aaaaa '::text; ---- false query T SELECT 'a '::varchar(3) > 'aaaaa '::text; ---- false query T SELECT 'a '::varchar(3) < 'aaaaa '::text; ---- true query T SELECT 'a '::varchar(3) = 'aaaaaa'::text; ---- false query T SELECT 'a '::varchar(3) > 'aaaaaa'::text; ---- false query T SELECT 'a '::varchar(3) < 'aaaaaa'::text; ---- true query T SELECT 'a '::varchar(3) = ''::text; ---- false query T SELECT 'a '::varchar(3) > ''::text; ---- true query T SELECT 'a '::varchar(3) < ''::text; ---- false query T SELECT 'a '::varchar(3) = ' '::text; ---- false query T SELECT 'a '::varchar(3) > ' '::text; ---- true query T SELECT 'a '::varchar(3) < ' '::text; ---- false query T SELECT 'aaaaa'::varchar(3) = 'a'::text; ---- false query T SELECT 'aaaaa'::varchar(3) > 'a'::text; ---- true query T SELECT 'aaaaa'::varchar(3) < 'a'::text; ---- false query T SELECT 'aaaaa'::varchar(3) = 'a '::text; ---- false query T SELECT 'aaaaa'::varchar(3) > 'a '::text; ---- true query T SELECT 'aaaaa'::varchar(3) < 'a '::text; ---- false query T SELECT 'aaaaa'::varchar(3) = 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa'::text; ---- true query T SELECT 'aaaaa'::varchar(3) = 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaa '::text; ---- true query T SELECT 'aaaaa'::varchar(3) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(3) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(3) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa'::varchar(3) = ''::text; ---- false query T SELECT 'aaaaa'::varchar(3) > ''::text; ---- true query T SELECT 'aaaaa'::varchar(3) < ''::text; ---- false query T SELECT 'aaaaa'::varchar(3) = ' '::text; ---- false query T SELECT 'aaaaa'::varchar(3) > ' '::text; ---- true query T SELECT 'aaaaa'::varchar(3) < ' '::text; ---- false query T SELECT 'aaaaa '::varchar(3) = 'a'::text; ---- false query T SELECT 'aaaaa '::varchar(3) > 'a'::text; ---- true query T SELECT 'aaaaa '::varchar(3) < 'a'::text; ---- false query T SELECT 'aaaaa '::varchar(3) = 'a '::text; ---- false query T SELECT 'aaaaa '::varchar(3) > 'a '::text; ---- true query T SELECT 'aaaaa '::varchar(3) < 'a '::text; ---- false query T SELECT 'aaaaa '::varchar(3) = 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa'::text; ---- true query T SELECT 'aaaaa '::varchar(3) = 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaa '::text; ---- true query T SELECT 'aaaaa '::varchar(3) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(3) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(3) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa '::varchar(3) = ''::text; ---- false query T SELECT 'aaaaa '::varchar(3) > ''::text; ---- true query T SELECT 'aaaaa '::varchar(3) < ''::text; ---- false query T SELECT 'aaaaa '::varchar(3) = ' '::text; ---- false query T SELECT 'aaaaa '::varchar(3) > ' '::text; ---- true query T SELECT 'aaaaa '::varchar(3) < ' '::text; ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a'::text; ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a'::text; ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a'::text; ---- false query T SELECT 'aaaaaa'::varchar(3) = 'a '::text; ---- false query T SELECT 'aaaaaa'::varchar(3) > 'a '::text; ---- true query T SELECT 'aaaaaa'::varchar(3) < 'a '::text; ---- false query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa'::text; ---- true query T SELECT 'aaaaaa'::varchar(3) = 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaa '::text; ---- true query T SELECT 'aaaaaa'::varchar(3) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(3) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(3) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaaa'::varchar(3) = ''::text; ---- false query T SELECT 'aaaaaa'::varchar(3) > ''::text; ---- true query T SELECT 'aaaaaa'::varchar(3) < ''::text; ---- false query T SELECT 'aaaaaa'::varchar(3) = ' '::text; ---- false query T SELECT 'aaaaaa'::varchar(3) > ' '::text; ---- true query T SELECT 'aaaaaa'::varchar(3) < ' '::text; ---- false query T SELECT ''::varchar(3) = 'a'::text; ---- false query T SELECT ''::varchar(3) > 'a'::text; ---- false query T SELECT ''::varchar(3) < 'a'::text; ---- true query T SELECT ''::varchar(3) = 'a '::text; ---- false query T SELECT ''::varchar(3) > 'a '::text; ---- false query T SELECT ''::varchar(3) < 'a '::text; ---- true query T SELECT ''::varchar(3) = 'aaaaa'::text; ---- false query T SELECT ''::varchar(3) > 'aaaaa'::text; ---- false query T SELECT ''::varchar(3) < 'aaaaa'::text; ---- true query T SELECT ''::varchar(3) = 'aaaaa '::text; ---- false query T SELECT ''::varchar(3) > 'aaaaa '::text; ---- false query T SELECT ''::varchar(3) < 'aaaaa '::text; ---- true query T SELECT ''::varchar(3) = 'aaaaaa'::text; ---- false query T SELECT ''::varchar(3) > 'aaaaaa'::text; ---- false query T SELECT ''::varchar(3) < 'aaaaaa'::text; ---- true query T SELECT ''::varchar(3) = ''::text; ---- true query T SELECT ''::varchar(3) > ''::text; ---- false query T SELECT ''::varchar(3) < ''::text; ---- false query T SELECT ''::varchar(3) = ' '::text; ---- false query T SELECT ''::varchar(3) > ' '::text; ---- false query T SELECT ''::varchar(3) < ' '::text; ---- true query T SELECT ' '::varchar(3) = 'a'::text; ---- false query T SELECT ' '::varchar(3) > 'a'::text; ---- false query T SELECT ' '::varchar(3) < 'a'::text; ---- true query T SELECT ' '::varchar(3) = 'a '::text; ---- false query T SELECT ' '::varchar(3) > 'a '::text; ---- false query T SELECT ' '::varchar(3) < 'a '::text; ---- true query T SELECT ' '::varchar(3) = 'aaaaa'::text; ---- false query T SELECT ' '::varchar(3) > 'aaaaa'::text; ---- false query T SELECT ' '::varchar(3) < 'aaaaa'::text; ---- true query T SELECT ' '::varchar(3) = 'aaaaa '::text; ---- false query T SELECT ' '::varchar(3) > 'aaaaa '::text; ---- false query T SELECT ' '::varchar(3) < 'aaaaa '::text; ---- true query T SELECT ' '::varchar(3) = 'aaaaaa'::text; ---- false query T SELECT ' '::varchar(3) > 'aaaaaa'::text; ---- false query T SELECT ' '::varchar(3) < 'aaaaaa'::text; ---- true query T SELECT ' '::varchar(3) = ''::text; ---- false query T SELECT ' '::varchar(3) > ''::text; ---- true query T SELECT ' '::varchar(3) < ''::text; ---- false query T SELECT ' '::varchar(3) = ' '::text; ---- true query T SELECT ' '::varchar(3) > ' '::text; ---- false query T SELECT ' '::varchar(3) < ' '::text; ---- false query T SELECT 'a'::varchar(30) = 'a'::char(3); ---- true query T SELECT 'a'::varchar(30) > 'a'::char(3); ---- false query T SELECT 'a'::varchar(30) < 'a'::char(3); ---- false query T SELECT 'a'::varchar(30) = 'a '::char(3); ---- true query T SELECT 'a'::varchar(30) > 'a '::char(3); ---- false query T SELECT 'a'::varchar(30) < 'a '::char(3); ---- false query T SELECT 'a'::varchar(30) = 'aaaaa'::char(3); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa'::char(3); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa'::char(3); ---- true query T SELECT 'a'::varchar(30) = 'aaaaa '::char(3); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa '::char(3); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa '::char(3); ---- true query T SELECT 'a'::varchar(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'a'::varchar(30) > 'aaaaaa'::char(3); ---- false query T SELECT 'a'::varchar(30) < 'aaaaaa'::char(3); ---- true query T SELECT 'a'::varchar(30) = ''::char(3); ---- false query T SELECT 'a'::varchar(30) > ''::char(3); ---- true query T SELECT 'a'::varchar(30) < ''::char(3); ---- false query T SELECT 'a'::varchar(30) = ' '::char(3); ---- false query T SELECT 'a'::varchar(30) > ' '::char(3); ---- true query T SELECT 'a'::varchar(30) < ' '::char(3); ---- false query T SELECT 'a '::varchar(30) = 'a'::char(3); ---- true query T SELECT 'a '::varchar(30) > 'a'::char(3); ---- false query T SELECT 'a '::varchar(30) < 'a'::char(3); ---- false query T SELECT 'a '::varchar(30) = 'a '::char(3); ---- true query T SELECT 'a '::varchar(30) > 'a '::char(3); ---- false query T SELECT 'a '::varchar(30) < 'a '::char(3); ---- false query T SELECT 'a '::varchar(30) = 'aaaaa'::char(3); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa'::char(3); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa'::char(3); ---- true query T SELECT 'a '::varchar(30) = 'aaaaa '::char(3); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa '::char(3); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa '::char(3); ---- true query T SELECT 'a '::varchar(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'a '::varchar(30) > 'aaaaaa'::char(3); ---- false query T SELECT 'a '::varchar(30) < 'aaaaaa'::char(3); ---- true query T SELECT 'a '::varchar(30) = ''::char(3); ---- false query T SELECT 'a '::varchar(30) > ''::char(3); ---- true query T SELECT 'a '::varchar(30) < ''::char(3); ---- false query T SELECT 'a '::varchar(30) = ' '::char(3); ---- false query T SELECT 'a '::varchar(30) > ' '::char(3); ---- true query T SELECT 'a '::varchar(30) < ' '::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a'::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a'::char(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a'::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a '::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a '::char(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a '::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) = ''::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) > ''::char(3); ---- true query T SELECT 'aaaaa'::varchar(30) < ''::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) = ' '::char(3); ---- false query T SELECT 'aaaaa'::varchar(30) > ' '::char(3); ---- true query T SELECT 'aaaaa'::varchar(30) < ' '::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a'::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a'::char(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a'::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a '::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a '::char(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a '::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) = ''::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) > ''::char(3); ---- true query T SELECT 'aaaaa '::varchar(30) < ''::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) = ' '::char(3); ---- false query T SELECT 'aaaaa '::varchar(30) > ' '::char(3); ---- true query T SELECT 'aaaaa '::varchar(30) < ' '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a'::char(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a '::char(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = ''::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > ''::char(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < ''::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = ' '::char(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > ' '::char(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < ' '::char(3); ---- false query T SELECT ''::varchar(30) = 'a'::char(3); ---- false query T SELECT ''::varchar(30) > 'a'::char(3); ---- false query T SELECT ''::varchar(30) < 'a'::char(3); ---- true query T SELECT ''::varchar(30) = 'a '::char(3); ---- false query T SELECT ''::varchar(30) > 'a '::char(3); ---- false query T SELECT ''::varchar(30) < 'a '::char(3); ---- true query T SELECT ''::varchar(30) = 'aaaaa'::char(3); ---- false query T SELECT ''::varchar(30) > 'aaaaa'::char(3); ---- false query T SELECT ''::varchar(30) < 'aaaaa'::char(3); ---- true query T SELECT ''::varchar(30) = 'aaaaa '::char(3); ---- false query T SELECT ''::varchar(30) > 'aaaaa '::char(3); ---- false query T SELECT ''::varchar(30) < 'aaaaa '::char(3); ---- true query T SELECT ''::varchar(30) = 'aaaaaa'::char(3); ---- false query T SELECT ''::varchar(30) > 'aaaaaa'::char(3); ---- false query T SELECT ''::varchar(30) < 'aaaaaa'::char(3); ---- true query T SELECT ''::varchar(30) = ''::char(3); ---- true query T SELECT ''::varchar(30) > ''::char(3); ---- false query T SELECT ''::varchar(30) < ''::char(3); ---- false query T SELECT ''::varchar(30) = ' '::char(3); ---- true query T SELECT ''::varchar(30) > ' '::char(3); ---- false query T SELECT ''::varchar(30) < ' '::char(3); ---- false query T SELECT ' '::varchar(30) = 'a'::char(3); ---- false query T SELECT ' '::varchar(30) > 'a'::char(3); ---- false query T SELECT ' '::varchar(30) < 'a'::char(3); ---- true query T SELECT ' '::varchar(30) = 'a '::char(3); ---- false query T SELECT ' '::varchar(30) > 'a '::char(3); ---- false query T SELECT ' '::varchar(30) < 'a '::char(3); ---- true query T SELECT ' '::varchar(30) = 'aaaaa'::char(3); ---- false query T SELECT ' '::varchar(30) > 'aaaaa'::char(3); ---- false query T SELECT ' '::varchar(30) < 'aaaaa'::char(3); ---- true query T SELECT ' '::varchar(30) = 'aaaaa '::char(3); ---- false query T SELECT ' '::varchar(30) > 'aaaaa '::char(3); ---- false query T SELECT ' '::varchar(30) < 'aaaaa '::char(3); ---- true query T SELECT ' '::varchar(30) = 'aaaaaa'::char(3); ---- false query T SELECT ' '::varchar(30) > 'aaaaaa'::char(3); ---- false query T SELECT ' '::varchar(30) < 'aaaaaa'::char(3); ---- true query T SELECT ' '::varchar(30) = ''::char(3); ---- true query T SELECT ' '::varchar(30) > ''::char(3); ---- false query T SELECT ' '::varchar(30) < ''::char(3); ---- false query T SELECT ' '::varchar(30) = ' '::char(3); ---- true query T SELECT ' '::varchar(30) > ' '::char(3); ---- false query T SELECT ' '::varchar(30) < ' '::char(3); ---- false query T SELECT 'a'::varchar(30) = 'a'::char(30); ---- true query T SELECT 'a'::varchar(30) > 'a'::char(30); ---- false query T SELECT 'a'::varchar(30) < 'a'::char(30); ---- false query T SELECT 'a'::varchar(30) = 'a '::char(30); ---- true query T SELECT 'a'::varchar(30) > 'a '::char(30); ---- false query T SELECT 'a'::varchar(30) < 'a '::char(30); ---- false query T SELECT 'a'::varchar(30) = 'aaaaa'::char(30); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa'::char(30); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa'::char(30); ---- true query T SELECT 'a'::varchar(30) = 'aaaaa '::char(30); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa '::char(30); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa '::char(30); ---- true query T SELECT 'a'::varchar(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'a'::varchar(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'a'::varchar(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'a'::varchar(30) = ''::char(30); ---- false query T SELECT 'a'::varchar(30) > ''::char(30); ---- true query T SELECT 'a'::varchar(30) < ''::char(30); ---- false query T SELECT 'a'::varchar(30) = ' '::char(30); ---- false query T SELECT 'a'::varchar(30) > ' '::char(30); ---- true query T SELECT 'a'::varchar(30) < ' '::char(30); ---- false query T SELECT 'a '::varchar(30) = 'a'::char(30); ---- true query T SELECT 'a '::varchar(30) > 'a'::char(30); ---- false query T SELECT 'a '::varchar(30) < 'a'::char(30); ---- false query T SELECT 'a '::varchar(30) = 'a '::char(30); ---- true query T SELECT 'a '::varchar(30) > 'a '::char(30); ---- false query T SELECT 'a '::varchar(30) < 'a '::char(30); ---- false query T SELECT 'a '::varchar(30) = 'aaaaa'::char(30); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa'::char(30); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa'::char(30); ---- true query T SELECT 'a '::varchar(30) = 'aaaaa '::char(30); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa '::char(30); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa '::char(30); ---- true query T SELECT 'a '::varchar(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'a '::varchar(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'a '::varchar(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'a '::varchar(30) = ''::char(30); ---- false query T SELECT 'a '::varchar(30) > ''::char(30); ---- true query T SELECT 'a '::varchar(30) < ''::char(30); ---- false query T SELECT 'a '::varchar(30) = ' '::char(30); ---- false query T SELECT 'a '::varchar(30) > ' '::char(30); ---- true query T SELECT 'a '::varchar(30) < ' '::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a'::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a'::char(30); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a'::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a '::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a '::char(30); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a '::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa'::varchar(30) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa'::varchar(30) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa'::varchar(30) = ''::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) > ''::char(30); ---- true query T SELECT 'aaaaa'::varchar(30) < ''::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) = ' '::char(30); ---- false query T SELECT 'aaaaa'::varchar(30) > ' '::char(30); ---- true query T SELECT 'aaaaa'::varchar(30) < ' '::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a'::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a'::char(30); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a'::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a '::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a '::char(30); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a '::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa '::varchar(30) > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa '::varchar(30) > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa '::varchar(30) = ''::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) > ''::char(30); ---- true query T SELECT 'aaaaa '::varchar(30) < ''::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) = ' '::char(30); ---- false query T SELECT 'aaaaa '::varchar(30) > ' '::char(30); ---- true query T SELECT 'aaaaa '::varchar(30) < ' '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a'::char(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a '::char(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa '::char(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::varchar(30) > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) < 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = ''::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > ''::char(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < ''::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = ' '::char(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > ' '::char(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < ' '::char(30); ---- false query T SELECT ''::varchar(30) = 'a'::char(30); ---- false query T SELECT ''::varchar(30) > 'a'::char(30); ---- false query T SELECT ''::varchar(30) < 'a'::char(30); ---- true query T SELECT ''::varchar(30) = 'a '::char(30); ---- false query T SELECT ''::varchar(30) > 'a '::char(30); ---- false query T SELECT ''::varchar(30) < 'a '::char(30); ---- true query T SELECT ''::varchar(30) = 'aaaaa'::char(30); ---- false query T SELECT ''::varchar(30) > 'aaaaa'::char(30); ---- false query T SELECT ''::varchar(30) < 'aaaaa'::char(30); ---- true query T SELECT ''::varchar(30) = 'aaaaa '::char(30); ---- false query T SELECT ''::varchar(30) > 'aaaaa '::char(30); ---- false query T SELECT ''::varchar(30) < 'aaaaa '::char(30); ---- true query T SELECT ''::varchar(30) = 'aaaaaa'::char(30); ---- false query T SELECT ''::varchar(30) > 'aaaaaa'::char(30); ---- false query T SELECT ''::varchar(30) < 'aaaaaa'::char(30); ---- true query T SELECT ''::varchar(30) = ''::char(30); ---- true query T SELECT ''::varchar(30) > ''::char(30); ---- false query T SELECT ''::varchar(30) < ''::char(30); ---- false query T SELECT ''::varchar(30) = ' '::char(30); ---- true query T SELECT ''::varchar(30) > ' '::char(30); ---- false query T SELECT ''::varchar(30) < ' '::char(30); ---- false query T SELECT ' '::varchar(30) = 'a'::char(30); ---- false query T SELECT ' '::varchar(30) > 'a'::char(30); ---- false query T SELECT ' '::varchar(30) < 'a'::char(30); ---- true query T SELECT ' '::varchar(30) = 'a '::char(30); ---- false query T SELECT ' '::varchar(30) > 'a '::char(30); ---- false query T SELECT ' '::varchar(30) < 'a '::char(30); ---- true query T SELECT ' '::varchar(30) = 'aaaaa'::char(30); ---- false query T SELECT ' '::varchar(30) > 'aaaaa'::char(30); ---- false query T SELECT ' '::varchar(30) < 'aaaaa'::char(30); ---- true query T SELECT ' '::varchar(30) = 'aaaaa '::char(30); ---- false query T SELECT ' '::varchar(30) > 'aaaaa '::char(30); ---- false query T SELECT ' '::varchar(30) < 'aaaaa '::char(30); ---- true query T SELECT ' '::varchar(30) = 'aaaaaa'::char(30); ---- false query T SELECT ' '::varchar(30) > 'aaaaaa'::char(30); ---- false query T SELECT ' '::varchar(30) < 'aaaaaa'::char(30); ---- true query T SELECT ' '::varchar(30) = ''::char(30); ---- true query T SELECT ' '::varchar(30) > ''::char(30); ---- false query T SELECT ' '::varchar(30) < ''::char(30); ---- false query T SELECT ' '::varchar(30) = ' '::char(30); ---- true query T SELECT ' '::varchar(30) > ' '::char(30); ---- false query T SELECT ' '::varchar(30) < ' '::char(30); ---- false query T SELECT 'a'::varchar(30) = 'a'::varchar(3); ---- true query T SELECT 'a'::varchar(30) > 'a'::varchar(3); ---- false query T SELECT 'a'::varchar(30) < 'a'::varchar(3); ---- false query T SELECT 'a'::varchar(30) = 'a '::varchar(3); ---- false query T SELECT 'a'::varchar(30) > 'a '::varchar(3); ---- false query T SELECT 'a'::varchar(30) < 'a '::varchar(3); ---- true query T SELECT 'a'::varchar(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a'::varchar(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a'::varchar(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::varchar(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a'::varchar(30) = ''::varchar(3); ---- false query T SELECT 'a'::varchar(30) > ''::varchar(3); ---- true query T SELECT 'a'::varchar(30) < ''::varchar(3); ---- false query T SELECT 'a'::varchar(30) = ' '::varchar(3); ---- false query T SELECT 'a'::varchar(30) > ' '::varchar(3); ---- true query T SELECT 'a'::varchar(30) < ' '::varchar(3); ---- false query T SELECT 'a '::varchar(30) = 'a'::varchar(3); ---- false query T SELECT 'a '::varchar(30) > 'a'::varchar(3); ---- true query T SELECT 'a '::varchar(30) < 'a'::varchar(3); ---- false query T SELECT 'a '::varchar(30) = 'a '::varchar(3); ---- true query T SELECT 'a '::varchar(30) > 'a '::varchar(3); ---- false query T SELECT 'a '::varchar(30) < 'a '::varchar(3); ---- false query T SELECT 'a '::varchar(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa'::varchar(3); ---- true query T SELECT 'a '::varchar(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa '::varchar(3); ---- true query T SELECT 'a '::varchar(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::varchar(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a '::varchar(30) = ''::varchar(3); ---- false query T SELECT 'a '::varchar(30) > ''::varchar(3); ---- true query T SELECT 'a '::varchar(30) < ''::varchar(3); ---- false query T SELECT 'a '::varchar(30) = ' '::varchar(3); ---- false query T SELECT 'a '::varchar(30) > ' '::varchar(3); ---- true query T SELECT 'a '::varchar(30) < ' '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(30) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) = ''::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) > ''::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(30) < ''::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) = ' '::varchar(3); ---- false query T SELECT 'aaaaa'::varchar(30) > ' '::varchar(3); ---- true query T SELECT 'aaaaa'::varchar(30) < ' '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a'::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a '::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) = ''::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) > ''::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(30) < ''::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) = ' '::varchar(3); ---- false query T SELECT 'aaaaa '::varchar(30) > ' '::varchar(3); ---- true query T SELECT 'aaaaa '::varchar(30) < ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a'::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a '::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = ''::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > ''::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < ''::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) = ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::varchar(30) > ' '::varchar(3); ---- true query T SELECT 'aaaaaa'::varchar(30) < ' '::varchar(3); ---- false query T SELECT ''::varchar(30) = 'a'::varchar(3); ---- false query T SELECT ''::varchar(30) > 'a'::varchar(3); ---- false query T SELECT ''::varchar(30) < 'a'::varchar(3); ---- true query T SELECT ''::varchar(30) = 'a '::varchar(3); ---- false query T SELECT ''::varchar(30) > 'a '::varchar(3); ---- false query T SELECT ''::varchar(30) < 'a '::varchar(3); ---- true query T SELECT ''::varchar(30) = 'aaaaa'::varchar(3); ---- false query T SELECT ''::varchar(30) > 'aaaaa'::varchar(3); ---- false query T SELECT ''::varchar(30) < 'aaaaa'::varchar(3); ---- true query T SELECT ''::varchar(30) = 'aaaaa '::varchar(3); ---- false query T SELECT ''::varchar(30) > 'aaaaa '::varchar(3); ---- false query T SELECT ''::varchar(30) < 'aaaaa '::varchar(3); ---- true query T SELECT ''::varchar(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT ''::varchar(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT ''::varchar(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT ''::varchar(30) = ''::varchar(3); ---- true query T SELECT ''::varchar(30) > ''::varchar(3); ---- false query T SELECT ''::varchar(30) < ''::varchar(3); ---- false query T SELECT ''::varchar(30) = ' '::varchar(3); ---- false query T SELECT ''::varchar(30) > ' '::varchar(3); ---- false query T SELECT ''::varchar(30) < ' '::varchar(3); ---- true query T SELECT ' '::varchar(30) = 'a'::varchar(3); ---- false query T SELECT ' '::varchar(30) > 'a'::varchar(3); ---- false query T SELECT ' '::varchar(30) < 'a'::varchar(3); ---- true query T SELECT ' '::varchar(30) = 'a '::varchar(3); ---- false query T SELECT ' '::varchar(30) > 'a '::varchar(3); ---- false query T SELECT ' '::varchar(30) < 'a '::varchar(3); ---- true query T SELECT ' '::varchar(30) = 'aaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(30) > 'aaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(30) < 'aaaaa'::varchar(3); ---- true query T SELECT ' '::varchar(30) = 'aaaaa '::varchar(3); ---- false query T SELECT ' '::varchar(30) > 'aaaaa '::varchar(3); ---- false query T SELECT ' '::varchar(30) < 'aaaaa '::varchar(3); ---- true query T SELECT ' '::varchar(30) = 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(30) > 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::varchar(30) < 'aaaaaa'::varchar(3); ---- true query T SELECT ' '::varchar(30) = ''::varchar(3); ---- false query T SELECT ' '::varchar(30) > ''::varchar(3); ---- true query T SELECT ' '::varchar(30) < ''::varchar(3); ---- false query T SELECT ' '::varchar(30) = ' '::varchar(3); ---- true query T SELECT ' '::varchar(30) > ' '::varchar(3); ---- false query T SELECT ' '::varchar(30) < ' '::varchar(3); ---- false query T SELECT 'a'::varchar(30) = 'a'::varchar(30); ---- true query T SELECT 'a'::varchar(30) > 'a'::varchar(30); ---- false query T SELECT 'a'::varchar(30) < 'a'::varchar(30); ---- false query T SELECT 'a'::varchar(30) = 'a '::varchar(30); ---- false query T SELECT 'a'::varchar(30) > 'a '::varchar(30); ---- false query T SELECT 'a'::varchar(30) < 'a '::varchar(30); ---- true query T SELECT 'a'::varchar(30) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a'::varchar(30) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::varchar(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::varchar(30) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a'::varchar(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::varchar(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a'::varchar(30) = ''::varchar(30); ---- false query T SELECT 'a'::varchar(30) > ''::varchar(30); ---- true query T SELECT 'a'::varchar(30) < ''::varchar(30); ---- false query T SELECT 'a'::varchar(30) = ' '::varchar(30); ---- false query T SELECT 'a'::varchar(30) > ' '::varchar(30); ---- true query T SELECT 'a'::varchar(30) < ' '::varchar(30); ---- false query T SELECT 'a '::varchar(30) = 'a'::varchar(30); ---- false query T SELECT 'a '::varchar(30) > 'a'::varchar(30); ---- true query T SELECT 'a '::varchar(30) < 'a'::varchar(30); ---- false query T SELECT 'a '::varchar(30) = 'a '::varchar(30); ---- true query T SELECT 'a '::varchar(30) > 'a '::varchar(30); ---- false query T SELECT 'a '::varchar(30) < 'a '::varchar(30); ---- false query T SELECT 'a '::varchar(30) = 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa'::varchar(30); ---- true query T SELECT 'a '::varchar(30) = 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::varchar(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::varchar(30) < 'aaaaa '::varchar(30); ---- true query T SELECT 'a '::varchar(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::varchar(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a '::varchar(30) = ''::varchar(30); ---- false query T SELECT 'a '::varchar(30) > ''::varchar(30); ---- true query T SELECT 'a '::varchar(30) < ''::varchar(30); ---- false query T SELECT 'a '::varchar(30) = ' '::varchar(30); ---- false query T SELECT 'a '::varchar(30) > ' '::varchar(30); ---- true query T SELECT 'a '::varchar(30) < ' '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(30) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(30) > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(30) = ''::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) > ''::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(30) < ''::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) = ' '::varchar(30); ---- false query T SELECT 'aaaaa'::varchar(30) > ' '::varchar(30); ---- true query T SELECT 'aaaaa'::varchar(30) < ' '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a'::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) > 'a '::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(30) < 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(30) > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) < 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(30) = ''::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) > ''::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(30) < ''::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) = ' '::varchar(30); ---- false query T SELECT 'aaaaa '::varchar(30) > ' '::varchar(30); ---- true query T SELECT 'aaaaa '::varchar(30) < ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a'::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a '::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) < 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = ''::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > ''::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < ''::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) = ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::varchar(30) > ' '::varchar(30); ---- true query T SELECT 'aaaaaa'::varchar(30) < ' '::varchar(30); ---- false query T SELECT ''::varchar(30) = 'a'::varchar(30); ---- false query T SELECT ''::varchar(30) > 'a'::varchar(30); ---- false query T SELECT ''::varchar(30) < 'a'::varchar(30); ---- true query T SELECT ''::varchar(30) = 'a '::varchar(30); ---- false query T SELECT ''::varchar(30) > 'a '::varchar(30); ---- false query T SELECT ''::varchar(30) < 'a '::varchar(30); ---- true query T SELECT ''::varchar(30) = 'aaaaa'::varchar(30); ---- false query T SELECT ''::varchar(30) > 'aaaaa'::varchar(30); ---- false query T SELECT ''::varchar(30) < 'aaaaa'::varchar(30); ---- true query T SELECT ''::varchar(30) = 'aaaaa '::varchar(30); ---- false query T SELECT ''::varchar(30) > 'aaaaa '::varchar(30); ---- false query T SELECT ''::varchar(30) < 'aaaaa '::varchar(30); ---- true query T SELECT ''::varchar(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT ''::varchar(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT ''::varchar(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT ''::varchar(30) = ''::varchar(30); ---- true query T SELECT ''::varchar(30) > ''::varchar(30); ---- false query T SELECT ''::varchar(30) < ''::varchar(30); ---- false query T SELECT ''::varchar(30) = ' '::varchar(30); ---- false query T SELECT ''::varchar(30) > ' '::varchar(30); ---- false query T SELECT ''::varchar(30) < ' '::varchar(30); ---- true query T SELECT ' '::varchar(30) = 'a'::varchar(30); ---- false query T SELECT ' '::varchar(30) > 'a'::varchar(30); ---- false query T SELECT ' '::varchar(30) < 'a'::varchar(30); ---- true query T SELECT ' '::varchar(30) = 'a '::varchar(30); ---- false query T SELECT ' '::varchar(30) > 'a '::varchar(30); ---- false query T SELECT ' '::varchar(30) < 'a '::varchar(30); ---- true query T SELECT ' '::varchar(30) = 'aaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(30) > 'aaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(30) < 'aaaaa'::varchar(30); ---- true query T SELECT ' '::varchar(30) = 'aaaaa '::varchar(30); ---- false query T SELECT ' '::varchar(30) > 'aaaaa '::varchar(30); ---- false query T SELECT ' '::varchar(30) < 'aaaaa '::varchar(30); ---- true query T SELECT ' '::varchar(30) = 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(30) > 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::varchar(30) < 'aaaaaa'::varchar(30); ---- true query T SELECT ' '::varchar(30) = ''::varchar(30); ---- false query T SELECT ' '::varchar(30) > ''::varchar(30); ---- true query T SELECT ' '::varchar(30) < ''::varchar(30); ---- false query T SELECT ' '::varchar(30) = ' '::varchar(30); ---- true query T SELECT ' '::varchar(30) > ' '::varchar(30); ---- false query T SELECT ' '::varchar(30) < ' '::varchar(30); ---- false query T SELECT 'a'::varchar(30) = 'a'::text; ---- true query T SELECT 'a'::varchar(30) > 'a'::text; ---- false query T SELECT 'a'::varchar(30) < 'a'::text; ---- false query T SELECT 'a'::varchar(30) = 'a '::text; ---- false query T SELECT 'a'::varchar(30) > 'a '::text; ---- false query T SELECT 'a'::varchar(30) < 'a '::text; ---- true query T SELECT 'a'::varchar(30) = 'aaaaa'::text; ---- false query T SELECT 'a'::varchar(30) > 'aaaaa'::text; ---- false query T SELECT 'a'::varchar(30) < 'aaaaa'::text; ---- true query T SELECT 'a'::varchar(30) = 'aaaaa '::text; ---- false query T SELECT 'a'::varchar(30) > 'aaaaa '::text; ---- false query T SELECT 'a'::varchar(30) < 'aaaaa '::text; ---- true query T SELECT 'a'::varchar(30) = 'aaaaaa'::text; ---- false query T SELECT 'a'::varchar(30) > 'aaaaaa'::text; ---- false query T SELECT 'a'::varchar(30) < 'aaaaaa'::text; ---- true query T SELECT 'a'::varchar(30) = ''::text; ---- false query T SELECT 'a'::varchar(30) > ''::text; ---- true query T SELECT 'a'::varchar(30) < ''::text; ---- false query T SELECT 'a'::varchar(30) = ' '::text; ---- false query T SELECT 'a'::varchar(30) > ' '::text; ---- true query T SELECT 'a'::varchar(30) < ' '::text; ---- false query T SELECT 'a '::varchar(30) = 'a'::text; ---- false query T SELECT 'a '::varchar(30) > 'a'::text; ---- true query T SELECT 'a '::varchar(30) < 'a'::text; ---- false query T SELECT 'a '::varchar(30) = 'a '::text; ---- true query T SELECT 'a '::varchar(30) > 'a '::text; ---- false query T SELECT 'a '::varchar(30) < 'a '::text; ---- false query T SELECT 'a '::varchar(30) = 'aaaaa'::text; ---- false query T SELECT 'a '::varchar(30) > 'aaaaa'::text; ---- false query T SELECT 'a '::varchar(30) < 'aaaaa'::text; ---- true query T SELECT 'a '::varchar(30) = 'aaaaa '::text; ---- false query T SELECT 'a '::varchar(30) > 'aaaaa '::text; ---- false query T SELECT 'a '::varchar(30) < 'aaaaa '::text; ---- true query T SELECT 'a '::varchar(30) = 'aaaaaa'::text; ---- false query T SELECT 'a '::varchar(30) > 'aaaaaa'::text; ---- false query T SELECT 'a '::varchar(30) < 'aaaaaa'::text; ---- true query T SELECT 'a '::varchar(30) = ''::text; ---- false query T SELECT 'a '::varchar(30) > ''::text; ---- true query T SELECT 'a '::varchar(30) < ''::text; ---- false query T SELECT 'a '::varchar(30) = ' '::text; ---- false query T SELECT 'a '::varchar(30) > ' '::text; ---- true query T SELECT 'a '::varchar(30) < ' '::text; ---- false query T SELECT 'aaaaa'::varchar(30) = 'a'::text; ---- false query T SELECT 'aaaaa'::varchar(30) > 'a'::text; ---- true query T SELECT 'aaaaa'::varchar(30) < 'a'::text; ---- false query T SELECT 'aaaaa'::varchar(30) = 'a '::text; ---- false query T SELECT 'aaaaa'::varchar(30) > 'a '::text; ---- true query T SELECT 'aaaaa'::varchar(30) < 'a '::text; ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa'::text; ---- true query T SELECT 'aaaaa'::varchar(30) > 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(30) = 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaa '::text; ---- true query T SELECT 'aaaaa'::varchar(30) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(30) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::varchar(30) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa'::varchar(30) = ''::text; ---- false query T SELECT 'aaaaa'::varchar(30) > ''::text; ---- true query T SELECT 'aaaaa'::varchar(30) < ''::text; ---- false query T SELECT 'aaaaa'::varchar(30) = ' '::text; ---- false query T SELECT 'aaaaa'::varchar(30) > ' '::text; ---- true query T SELECT 'aaaaa'::varchar(30) < ' '::text; ---- false query T SELECT 'aaaaa '::varchar(30) = 'a'::text; ---- false query T SELECT 'aaaaa '::varchar(30) > 'a'::text; ---- true query T SELECT 'aaaaa '::varchar(30) < 'a'::text; ---- false query T SELECT 'aaaaa '::varchar(30) = 'a '::text; ---- false query T SELECT 'aaaaa '::varchar(30) > 'a '::text; ---- true query T SELECT 'aaaaa '::varchar(30) < 'a '::text; ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaa'::text; ---- true query T SELECT 'aaaaa '::varchar(30) < 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaa '::text; ---- true query T SELECT 'aaaaa '::varchar(30) > 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::varchar(30) < 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::varchar(30) = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(30) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::varchar(30) < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa '::varchar(30) = ''::text; ---- false query T SELECT 'aaaaa '::varchar(30) > ''::text; ---- true query T SELECT 'aaaaa '::varchar(30) < ''::text; ---- false query T SELECT 'aaaaa '::varchar(30) = ' '::text; ---- false query T SELECT 'aaaaa '::varchar(30) > ' '::text; ---- true query T SELECT 'aaaaa '::varchar(30) < ' '::text; ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a'::text; ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a'::text; ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a'::text; ---- false query T SELECT 'aaaaaa'::varchar(30) = 'a '::text; ---- false query T SELECT 'aaaaaa'::varchar(30) > 'a '::text; ---- true query T SELECT 'aaaaaa'::varchar(30) < 'a '::text; ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa'::text; ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::varchar(30) > 'aaaaa '::text; ---- true query T SELECT 'aaaaaa'::varchar(30) < 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::varchar(30) = 'aaaaaa'::text; ---- true query T SELECT 'aaaaaa'::varchar(30) > 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(30) < 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::varchar(30) = ''::text; ---- false query T SELECT 'aaaaaa'::varchar(30) > ''::text; ---- true query T SELECT 'aaaaaa'::varchar(30) < ''::text; ---- false query T SELECT 'aaaaaa'::varchar(30) = ' '::text; ---- false query T SELECT 'aaaaaa'::varchar(30) > ' '::text; ---- true query T SELECT 'aaaaaa'::varchar(30) < ' '::text; ---- false query T SELECT ''::varchar(30) = 'a'::text; ---- false query T SELECT ''::varchar(30) > 'a'::text; ---- false query T SELECT ''::varchar(30) < 'a'::text; ---- true query T SELECT ''::varchar(30) = 'a '::text; ---- false query T SELECT ''::varchar(30) > 'a '::text; ---- false query T SELECT ''::varchar(30) < 'a '::text; ---- true query T SELECT ''::varchar(30) = 'aaaaa'::text; ---- false query T SELECT ''::varchar(30) > 'aaaaa'::text; ---- false query T SELECT ''::varchar(30) < 'aaaaa'::text; ---- true query T SELECT ''::varchar(30) = 'aaaaa '::text; ---- false query T SELECT ''::varchar(30) > 'aaaaa '::text; ---- false query T SELECT ''::varchar(30) < 'aaaaa '::text; ---- true query T SELECT ''::varchar(30) = 'aaaaaa'::text; ---- false query T SELECT ''::varchar(30) > 'aaaaaa'::text; ---- false query T SELECT ''::varchar(30) < 'aaaaaa'::text; ---- true query T SELECT ''::varchar(30) = ''::text; ---- true query T SELECT ''::varchar(30) > ''::text; ---- false query T SELECT ''::varchar(30) < ''::text; ---- false query T SELECT ''::varchar(30) = ' '::text; ---- false query T SELECT ''::varchar(30) > ' '::text; ---- false query T SELECT ''::varchar(30) < ' '::text; ---- true query T SELECT ' '::varchar(30) = 'a'::text; ---- false query T SELECT ' '::varchar(30) > 'a'::text; ---- false query T SELECT ' '::varchar(30) < 'a'::text; ---- true query T SELECT ' '::varchar(30) = 'a '::text; ---- false query T SELECT ' '::varchar(30) > 'a '::text; ---- false query T SELECT ' '::varchar(30) < 'a '::text; ---- true query T SELECT ' '::varchar(30) = 'aaaaa'::text; ---- false query T SELECT ' '::varchar(30) > 'aaaaa'::text; ---- false query T SELECT ' '::varchar(30) < 'aaaaa'::text; ---- true query T SELECT ' '::varchar(30) = 'aaaaa '::text; ---- false query T SELECT ' '::varchar(30) > 'aaaaa '::text; ---- false query T SELECT ' '::varchar(30) < 'aaaaa '::text; ---- true query T SELECT ' '::varchar(30) = 'aaaaaa'::text; ---- false query T SELECT ' '::varchar(30) > 'aaaaaa'::text; ---- false query T SELECT ' '::varchar(30) < 'aaaaaa'::text; ---- true query T SELECT ' '::varchar(30) = ''::text; ---- false query T SELECT ' '::varchar(30) > ''::text; ---- true query T SELECT ' '::varchar(30) < ''::text; ---- false query T SELECT ' '::varchar(30) = ' '::text; ---- true query T SELECT ' '::varchar(30) > ' '::text; ---- false query T SELECT ' '::varchar(30) < ' '::text; ---- false query T SELECT 'a'::text = 'a'::char(3); ---- true query T SELECT 'a'::text > 'a'::char(3); ---- false query T SELECT 'a'::text < 'a'::char(3); ---- false query T SELECT 'a'::text = 'a '::char(3); ---- true query T SELECT 'a'::text > 'a '::char(3); ---- false query T SELECT 'a'::text < 'a '::char(3); ---- false query T SELECT 'a'::text = 'aaaaa'::char(3); ---- false query T SELECT 'a'::text > 'aaaaa'::char(3); ---- false query T SELECT 'a'::text < 'aaaaa'::char(3); ---- true query T SELECT 'a'::text = 'aaaaa '::char(3); ---- false query T SELECT 'a'::text > 'aaaaa '::char(3); ---- false query T SELECT 'a'::text < 'aaaaa '::char(3); ---- true query T SELECT 'a'::text = 'aaaaaa'::char(3); ---- false query T SELECT 'a'::text > 'aaaaaa'::char(3); ---- false query T SELECT 'a'::text < 'aaaaaa'::char(3); ---- true query T SELECT 'a'::text = ''::char(3); ---- false query T SELECT 'a'::text > ''::char(3); ---- true query T SELECT 'a'::text < ''::char(3); ---- false query T SELECT 'a'::text = ' '::char(3); ---- false query T SELECT 'a'::text > ' '::char(3); ---- true query T SELECT 'a'::text < ' '::char(3); ---- false query T SELECT 'a '::text = 'a'::char(3); ---- false query T SELECT 'a '::text > 'a'::char(3); ---- true query T SELECT 'a '::text < 'a'::char(3); ---- false query T SELECT 'a '::text = 'a '::char(3); ---- false query T SELECT 'a '::text > 'a '::char(3); ---- true query T SELECT 'a '::text < 'a '::char(3); ---- false query T SELECT 'a '::text = 'aaaaa'::char(3); ---- false query T SELECT 'a '::text > 'aaaaa'::char(3); ---- false query T SELECT 'a '::text < 'aaaaa'::char(3); ---- true query T SELECT 'a '::text = 'aaaaa '::char(3); ---- false query T SELECT 'a '::text > 'aaaaa '::char(3); ---- false query T SELECT 'a '::text < 'aaaaa '::char(3); ---- true query T SELECT 'a '::text = 'aaaaaa'::char(3); ---- false query T SELECT 'a '::text > 'aaaaaa'::char(3); ---- false query T SELECT 'a '::text < 'aaaaaa'::char(3); ---- true query T SELECT 'a '::text = ''::char(3); ---- false query T SELECT 'a '::text > ''::char(3); ---- true query T SELECT 'a '::text < ''::char(3); ---- false query T SELECT 'a '::text = ' '::char(3); ---- false query T SELECT 'a '::text > ' '::char(3); ---- true query T SELECT 'a '::text < ' '::char(3); ---- false query T SELECT 'aaaaa'::text = 'a'::char(3); ---- false query T SELECT 'aaaaa'::text > 'a'::char(3); ---- true query T SELECT 'aaaaa'::text < 'a'::char(3); ---- false query T SELECT 'aaaaa'::text = 'a '::char(3); ---- false query T SELECT 'aaaaa'::text > 'a '::char(3); ---- true query T SELECT 'aaaaa'::text < 'a '::char(3); ---- false query T SELECT 'aaaaa'::text = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::text > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa'::text < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa'::text = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::text > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa'::text < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa'::text = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::text > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa'::text < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa'::text = ''::char(3); ---- false query T SELECT 'aaaaa'::text > ''::char(3); ---- true query T SELECT 'aaaaa'::text < ''::char(3); ---- false query T SELECT 'aaaaa'::text = ' '::char(3); ---- false query T SELECT 'aaaaa'::text > ' '::char(3); ---- true query T SELECT 'aaaaa'::text < ' '::char(3); ---- false query T SELECT 'aaaaa '::text = 'a'::char(3); ---- false query T SELECT 'aaaaa '::text > 'a'::char(3); ---- true query T SELECT 'aaaaa '::text < 'a'::char(3); ---- false query T SELECT 'aaaaa '::text = 'a '::char(3); ---- false query T SELECT 'aaaaa '::text > 'a '::char(3); ---- true query T SELECT 'aaaaa '::text < 'a '::char(3); ---- false query T SELECT 'aaaaa '::text = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::text > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaa '::text < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaa '::text = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::text > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaa '::text < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaa '::text = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::text > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaa '::text < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaa '::text = ''::char(3); ---- false query T SELECT 'aaaaa '::text > ''::char(3); ---- true query T SELECT 'aaaaa '::text < ''::char(3); ---- false query T SELECT 'aaaaa '::text = ' '::char(3); ---- false query T SELECT 'aaaaa '::text > ' '::char(3); ---- true query T SELECT 'aaaaa '::text < ' '::char(3); ---- false query T SELECT 'aaaaaa'::text = 'a'::char(3); ---- false query T SELECT 'aaaaaa'::text > 'a'::char(3); ---- true query T SELECT 'aaaaaa'::text < 'a'::char(3); ---- false query T SELECT 'aaaaaa'::text = 'a '::char(3); ---- false query T SELECT 'aaaaaa'::text > 'a '::char(3); ---- true query T SELECT 'aaaaaa'::text < 'a '::char(3); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa '::char(3); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa '::char(3); ---- false query T SELECT 'aaaaaa'::text = 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::text > 'aaaaaa'::char(3); ---- true query T SELECT 'aaaaaa'::text < 'aaaaaa'::char(3); ---- false query T SELECT 'aaaaaa'::text = ''::char(3); ---- false query T SELECT 'aaaaaa'::text > ''::char(3); ---- true query T SELECT 'aaaaaa'::text < ''::char(3); ---- false query T SELECT 'aaaaaa'::text = ' '::char(3); ---- false query T SELECT 'aaaaaa'::text > ' '::char(3); ---- true query T SELECT 'aaaaaa'::text < ' '::char(3); ---- false query T SELECT ''::text = 'a'::char(3); ---- false query T SELECT ''::text > 'a'::char(3); ---- false query T SELECT ''::text < 'a'::char(3); ---- true query T SELECT ''::text = 'a '::char(3); ---- false query T SELECT ''::text > 'a '::char(3); ---- false query T SELECT ''::text < 'a '::char(3); ---- true query T SELECT ''::text = 'aaaaa'::char(3); ---- false query T SELECT ''::text > 'aaaaa'::char(3); ---- false query T SELECT ''::text < 'aaaaa'::char(3); ---- true query T SELECT ''::text = 'aaaaa '::char(3); ---- false query T SELECT ''::text > 'aaaaa '::char(3); ---- false query T SELECT ''::text < 'aaaaa '::char(3); ---- true query T SELECT ''::text = 'aaaaaa'::char(3); ---- false query T SELECT ''::text > 'aaaaaa'::char(3); ---- false query T SELECT ''::text < 'aaaaaa'::char(3); ---- true query T SELECT ''::text = ''::char(3); ---- true query T SELECT ''::text > ''::char(3); ---- false query T SELECT ''::text < ''::char(3); ---- false query T SELECT ''::text = ' '::char(3); ---- true query T SELECT ''::text > ' '::char(3); ---- false query T SELECT ''::text < ' '::char(3); ---- false query T SELECT ' '::text = 'a'::char(3); ---- false query T SELECT ' '::text > 'a'::char(3); ---- false query T SELECT ' '::text < 'a'::char(3); ---- true query T SELECT ' '::text = 'a '::char(3); ---- false query T SELECT ' '::text > 'a '::char(3); ---- false query T SELECT ' '::text < 'a '::char(3); ---- true query T SELECT ' '::text = 'aaaaa'::char(3); ---- false query T SELECT ' '::text > 'aaaaa'::char(3); ---- false query T SELECT ' '::text < 'aaaaa'::char(3); ---- true query T SELECT ' '::text = 'aaaaa '::char(3); ---- false query T SELECT ' '::text > 'aaaaa '::char(3); ---- false query T SELECT ' '::text < 'aaaaa '::char(3); ---- true query T SELECT ' '::text = 'aaaaaa'::char(3); ---- false query T SELECT ' '::text > 'aaaaaa'::char(3); ---- false query T SELECT ' '::text < 'aaaaaa'::char(3); ---- true query T SELECT ' '::text = ''::char(3); ---- false query T SELECT ' '::text > ''::char(3); ---- true query T SELECT ' '::text < ''::char(3); ---- false query T SELECT ' '::text = ' '::char(3); ---- false query T SELECT ' '::text > ' '::char(3); ---- true query T SELECT ' '::text < ' '::char(3); ---- false query T SELECT 'a'::text = 'a'::char(30); ---- true query T SELECT 'a'::text > 'a'::char(30); ---- false query T SELECT 'a'::text < 'a'::char(30); ---- false query T SELECT 'a'::text = 'a '::char(30); ---- true query T SELECT 'a'::text > 'a '::char(30); ---- false query T SELECT 'a'::text < 'a '::char(30); ---- false query T SELECT 'a'::text = 'aaaaa'::char(30); ---- false query T SELECT 'a'::text > 'aaaaa'::char(30); ---- false query T SELECT 'a'::text < 'aaaaa'::char(30); ---- true query T SELECT 'a'::text = 'aaaaa '::char(30); ---- false query T SELECT 'a'::text > 'aaaaa '::char(30); ---- false query T SELECT 'a'::text < 'aaaaa '::char(30); ---- true query T SELECT 'a'::text = 'aaaaaa'::char(30); ---- false query T SELECT 'a'::text > 'aaaaaa'::char(30); ---- false query T SELECT 'a'::text < 'aaaaaa'::char(30); ---- true query T SELECT 'a'::text = ''::char(30); ---- false query T SELECT 'a'::text > ''::char(30); ---- true query T SELECT 'a'::text < ''::char(30); ---- false query T SELECT 'a'::text = ' '::char(30); ---- false query T SELECT 'a'::text > ' '::char(30); ---- true query T SELECT 'a'::text < ' '::char(30); ---- false query T SELECT 'a '::text = 'a'::char(30); ---- false query T SELECT 'a '::text > 'a'::char(30); ---- true query T SELECT 'a '::text < 'a'::char(30); ---- false query T SELECT 'a '::text = 'a '::char(30); ---- false query T SELECT 'a '::text > 'a '::char(30); ---- true query T SELECT 'a '::text < 'a '::char(30); ---- false query T SELECT 'a '::text = 'aaaaa'::char(30); ---- false query T SELECT 'a '::text > 'aaaaa'::char(30); ---- false query T SELECT 'a '::text < 'aaaaa'::char(30); ---- true query T SELECT 'a '::text = 'aaaaa '::char(30); ---- false query T SELECT 'a '::text > 'aaaaa '::char(30); ---- false query T SELECT 'a '::text < 'aaaaa '::char(30); ---- true query T SELECT 'a '::text = 'aaaaaa'::char(30); ---- false query T SELECT 'a '::text > 'aaaaaa'::char(30); ---- false query T SELECT 'a '::text < 'aaaaaa'::char(30); ---- true query T SELECT 'a '::text = ''::char(30); ---- false query T SELECT 'a '::text > ''::char(30); ---- true query T SELECT 'a '::text < ''::char(30); ---- false query T SELECT 'a '::text = ' '::char(30); ---- false query T SELECT 'a '::text > ' '::char(30); ---- true query T SELECT 'a '::text < ' '::char(30); ---- false query T SELECT 'aaaaa'::text = 'a'::char(30); ---- false query T SELECT 'aaaaa'::text > 'a'::char(30); ---- true query T SELECT 'aaaaa'::text < 'a'::char(30); ---- false query T SELECT 'aaaaa'::text = 'a '::char(30); ---- false query T SELECT 'aaaaa'::text > 'a '::char(30); ---- true query T SELECT 'aaaaa'::text < 'a '::char(30); ---- false query T SELECT 'aaaaa'::text = 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa'::text > 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::text < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa'::text = 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa'::text > 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::text < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa'::text = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::text > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa'::text < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa'::text = ''::char(30); ---- false query T SELECT 'aaaaa'::text > ''::char(30); ---- true query T SELECT 'aaaaa'::text < ''::char(30); ---- false query T SELECT 'aaaaa'::text = ' '::char(30); ---- false query T SELECT 'aaaaa'::text > ' '::char(30); ---- true query T SELECT 'aaaaa'::text < ' '::char(30); ---- false query T SELECT 'aaaaa '::text = 'a'::char(30); ---- false query T SELECT 'aaaaa '::text > 'a'::char(30); ---- true query T SELECT 'aaaaa '::text < 'a'::char(30); ---- false query T SELECT 'aaaaa '::text = 'a '::char(30); ---- false query T SELECT 'aaaaa '::text > 'a '::char(30); ---- true query T SELECT 'aaaaa '::text < 'a '::char(30); ---- false query T SELECT 'aaaaa '::text = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::text > 'aaaaa'::char(30); ---- true query T SELECT 'aaaaa '::text < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaa '::text = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::text > 'aaaaa '::char(30); ---- true query T SELECT 'aaaaa '::text < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaa '::text = 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::text > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaa '::text < 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaa '::text = ''::char(30); ---- false query T SELECT 'aaaaa '::text > ''::char(30); ---- true query T SELECT 'aaaaa '::text < ''::char(30); ---- false query T SELECT 'aaaaa '::text = ' '::char(30); ---- false query T SELECT 'aaaaa '::text > ' '::char(30); ---- true query T SELECT 'aaaaa '::text < ' '::char(30); ---- false query T SELECT 'aaaaaa'::text = 'a'::char(30); ---- false query T SELECT 'aaaaaa'::text > 'a'::char(30); ---- true query T SELECT 'aaaaaa'::text < 'a'::char(30); ---- false query T SELECT 'aaaaaa'::text = 'a '::char(30); ---- false query T SELECT 'aaaaaa'::text > 'a '::char(30); ---- true query T SELECT 'aaaaaa'::text < 'a '::char(30); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa '::char(30); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa '::char(30); ---- false query T SELECT 'aaaaaa'::text = 'aaaaaa'::char(30); ---- true query T SELECT 'aaaaaa'::text > 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::text < 'aaaaaa'::char(30); ---- false query T SELECT 'aaaaaa'::text = ''::char(30); ---- false query T SELECT 'aaaaaa'::text > ''::char(30); ---- true query T SELECT 'aaaaaa'::text < ''::char(30); ---- false query T SELECT 'aaaaaa'::text = ' '::char(30); ---- false query T SELECT 'aaaaaa'::text > ' '::char(30); ---- true query T SELECT 'aaaaaa'::text < ' '::char(30); ---- false query T SELECT ''::text = 'a'::char(30); ---- false query T SELECT ''::text > 'a'::char(30); ---- false query T SELECT ''::text < 'a'::char(30); ---- true query T SELECT ''::text = 'a '::char(30); ---- false query T SELECT ''::text > 'a '::char(30); ---- false query T SELECT ''::text < 'a '::char(30); ---- true query T SELECT ''::text = 'aaaaa'::char(30); ---- false query T SELECT ''::text > 'aaaaa'::char(30); ---- false query T SELECT ''::text < 'aaaaa'::char(30); ---- true query T SELECT ''::text = 'aaaaa '::char(30); ---- false query T SELECT ''::text > 'aaaaa '::char(30); ---- false query T SELECT ''::text < 'aaaaa '::char(30); ---- true query T SELECT ''::text = 'aaaaaa'::char(30); ---- false query T SELECT ''::text > 'aaaaaa'::char(30); ---- false query T SELECT ''::text < 'aaaaaa'::char(30); ---- true query T SELECT ''::text = ''::char(30); ---- true query T SELECT ''::text > ''::char(30); ---- false query T SELECT ''::text < ''::char(30); ---- false query T SELECT ''::text = ' '::char(30); ---- true query T SELECT ''::text > ' '::char(30); ---- false query T SELECT ''::text < ' '::char(30); ---- false query T SELECT ' '::text = 'a'::char(30); ---- false query T SELECT ' '::text > 'a'::char(30); ---- false query T SELECT ' '::text < 'a'::char(30); ---- true query T SELECT ' '::text = 'a '::char(30); ---- false query T SELECT ' '::text > 'a '::char(30); ---- false query T SELECT ' '::text < 'a '::char(30); ---- true query T SELECT ' '::text = 'aaaaa'::char(30); ---- false query T SELECT ' '::text > 'aaaaa'::char(30); ---- false query T SELECT ' '::text < 'aaaaa'::char(30); ---- true query T SELECT ' '::text = 'aaaaa '::char(30); ---- false query T SELECT ' '::text > 'aaaaa '::char(30); ---- false query T SELECT ' '::text < 'aaaaa '::char(30); ---- true query T SELECT ' '::text = 'aaaaaa'::char(30); ---- false query T SELECT ' '::text > 'aaaaaa'::char(30); ---- false query T SELECT ' '::text < 'aaaaaa'::char(30); ---- true query T SELECT ' '::text = ''::char(30); ---- false query T SELECT ' '::text > ''::char(30); ---- true query T SELECT ' '::text < ''::char(30); ---- false query T SELECT ' '::text = ' '::char(30); ---- false query T SELECT ' '::text > ' '::char(30); ---- true query T SELECT ' '::text < ' '::char(30); ---- false query T SELECT 'a'::text = 'a'::varchar(3); ---- true query T SELECT 'a'::text > 'a'::varchar(3); ---- false query T SELECT 'a'::text < 'a'::varchar(3); ---- false query T SELECT 'a'::text = 'a '::varchar(3); ---- false query T SELECT 'a'::text > 'a '::varchar(3); ---- false query T SELECT 'a'::text < 'a '::varchar(3); ---- true query T SELECT 'a'::text = 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::text > 'aaaaa'::varchar(3); ---- false query T SELECT 'a'::text < 'aaaaa'::varchar(3); ---- true query T SELECT 'a'::text = 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::text > 'aaaaa '::varchar(3); ---- false query T SELECT 'a'::text < 'aaaaa '::varchar(3); ---- true query T SELECT 'a'::text = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::text > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a'::text < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a'::text = ''::varchar(3); ---- false query T SELECT 'a'::text > ''::varchar(3); ---- true query T SELECT 'a'::text < ''::varchar(3); ---- false query T SELECT 'a'::text = ' '::varchar(3); ---- false query T SELECT 'a'::text > ' '::varchar(3); ---- true query T SELECT 'a'::text < ' '::varchar(3); ---- false query T SELECT 'a '::text = 'a'::varchar(3); ---- false query T SELECT 'a '::text > 'a'::varchar(3); ---- true query T SELECT 'a '::text < 'a'::varchar(3); ---- false query T SELECT 'a '::text = 'a '::varchar(3); ---- true query T SELECT 'a '::text > 'a '::varchar(3); ---- false query T SELECT 'a '::text < 'a '::varchar(3); ---- false query T SELECT 'a '::text = 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::text > 'aaaaa'::varchar(3); ---- false query T SELECT 'a '::text < 'aaaaa'::varchar(3); ---- true query T SELECT 'a '::text = 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::text > 'aaaaa '::varchar(3); ---- false query T SELECT 'a '::text < 'aaaaa '::varchar(3); ---- true query T SELECT 'a '::text = 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::text > 'aaaaaa'::varchar(3); ---- false query T SELECT 'a '::text < 'aaaaaa'::varchar(3); ---- true query T SELECT 'a '::text = ''::varchar(3); ---- false query T SELECT 'a '::text > ''::varchar(3); ---- true query T SELECT 'a '::text < ''::varchar(3); ---- false query T SELECT 'a '::text = ' '::varchar(3); ---- false query T SELECT 'a '::text > ' '::varchar(3); ---- true query T SELECT 'a '::text < ' '::varchar(3); ---- false query T SELECT 'aaaaa'::text = 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::text > 'a'::varchar(3); ---- true query T SELECT 'aaaaa'::text < 'a'::varchar(3); ---- false query T SELECT 'aaaaa'::text = 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::text > 'a '::varchar(3); ---- true query T SELECT 'aaaaa'::text < 'a '::varchar(3); ---- false query T SELECT 'aaaaa'::text = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::text > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::text < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::text = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::text > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa'::text < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa'::text = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::text > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa'::text < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa'::text = ''::varchar(3); ---- false query T SELECT 'aaaaa'::text > ''::varchar(3); ---- true query T SELECT 'aaaaa'::text < ''::varchar(3); ---- false query T SELECT 'aaaaa'::text = ' '::varchar(3); ---- false query T SELECT 'aaaaa'::text > ' '::varchar(3); ---- true query T SELECT 'aaaaa'::text < ' '::varchar(3); ---- false query T SELECT 'aaaaa '::text = 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::text > 'a'::varchar(3); ---- true query T SELECT 'aaaaa '::text < 'a'::varchar(3); ---- false query T SELECT 'aaaaa '::text = 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::text > 'a '::varchar(3); ---- true query T SELECT 'aaaaa '::text < 'a '::varchar(3); ---- false query T SELECT 'aaaaa '::text = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::text > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::text < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::text = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::text > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaa '::text < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaa '::text = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::text > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaa '::text < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaa '::text = ''::varchar(3); ---- false query T SELECT 'aaaaa '::text > ''::varchar(3); ---- true query T SELECT 'aaaaa '::text < ''::varchar(3); ---- false query T SELECT 'aaaaa '::text = ' '::varchar(3); ---- false query T SELECT 'aaaaa '::text > ' '::varchar(3); ---- true query T SELECT 'aaaaa '::text < ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::text = 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::text > 'a'::varchar(3); ---- true query T SELECT 'aaaaaa'::text < 'a'::varchar(3); ---- false query T SELECT 'aaaaaa'::text = 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::text > 'a '::varchar(3); ---- true query T SELECT 'aaaaaa'::text < 'a '::varchar(3); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa '::varchar(3); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa '::varchar(3); ---- false query T SELECT 'aaaaaa'::text = 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::text > 'aaaaaa'::varchar(3); ---- true query T SELECT 'aaaaaa'::text < 'aaaaaa'::varchar(3); ---- false query T SELECT 'aaaaaa'::text = ''::varchar(3); ---- false query T SELECT 'aaaaaa'::text > ''::varchar(3); ---- true query T SELECT 'aaaaaa'::text < ''::varchar(3); ---- false query T SELECT 'aaaaaa'::text = ' '::varchar(3); ---- false query T SELECT 'aaaaaa'::text > ' '::varchar(3); ---- true query T SELECT 'aaaaaa'::text < ' '::varchar(3); ---- false query T SELECT ''::text = 'a'::varchar(3); ---- false query T SELECT ''::text > 'a'::varchar(3); ---- false query T SELECT ''::text < 'a'::varchar(3); ---- true query T SELECT ''::text = 'a '::varchar(3); ---- false query T SELECT ''::text > 'a '::varchar(3); ---- false query T SELECT ''::text < 'a '::varchar(3); ---- true query T SELECT ''::text = 'aaaaa'::varchar(3); ---- false query T SELECT ''::text > 'aaaaa'::varchar(3); ---- false query T SELECT ''::text < 'aaaaa'::varchar(3); ---- true query T SELECT ''::text = 'aaaaa '::varchar(3); ---- false query T SELECT ''::text > 'aaaaa '::varchar(3); ---- false query T SELECT ''::text < 'aaaaa '::varchar(3); ---- true query T SELECT ''::text = 'aaaaaa'::varchar(3); ---- false query T SELECT ''::text > 'aaaaaa'::varchar(3); ---- false query T SELECT ''::text < 'aaaaaa'::varchar(3); ---- true query T SELECT ''::text = ''::varchar(3); ---- true query T SELECT ''::text > ''::varchar(3); ---- false query T SELECT ''::text < ''::varchar(3); ---- false query T SELECT ''::text = ' '::varchar(3); ---- false query T SELECT ''::text > ' '::varchar(3); ---- false query T SELECT ''::text < ' '::varchar(3); ---- true query T SELECT ' '::text = 'a'::varchar(3); ---- false query T SELECT ' '::text > 'a'::varchar(3); ---- false query T SELECT ' '::text < 'a'::varchar(3); ---- true query T SELECT ' '::text = 'a '::varchar(3); ---- false query T SELECT ' '::text > 'a '::varchar(3); ---- false query T SELECT ' '::text < 'a '::varchar(3); ---- true query T SELECT ' '::text = 'aaaaa'::varchar(3); ---- false query T SELECT ' '::text > 'aaaaa'::varchar(3); ---- false query T SELECT ' '::text < 'aaaaa'::varchar(3); ---- true query T SELECT ' '::text = 'aaaaa '::varchar(3); ---- false query T SELECT ' '::text > 'aaaaa '::varchar(3); ---- false query T SELECT ' '::text < 'aaaaa '::varchar(3); ---- true query T SELECT ' '::text = 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::text > 'aaaaaa'::varchar(3); ---- false query T SELECT ' '::text < 'aaaaaa'::varchar(3); ---- true query T SELECT ' '::text = ''::varchar(3); ---- false query T SELECT ' '::text > ''::varchar(3); ---- true query T SELECT ' '::text < ''::varchar(3); ---- false query T SELECT ' '::text = ' '::varchar(3); ---- true query T SELECT ' '::text > ' '::varchar(3); ---- false query T SELECT ' '::text < ' '::varchar(3); ---- false query T SELECT 'a'::text = 'a'::varchar(30); ---- true query T SELECT 'a'::text > 'a'::varchar(30); ---- false query T SELECT 'a'::text < 'a'::varchar(30); ---- false query T SELECT 'a'::text = 'a '::varchar(30); ---- false query T SELECT 'a'::text > 'a '::varchar(30); ---- false query T SELECT 'a'::text < 'a '::varchar(30); ---- true query T SELECT 'a'::text = 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::text > 'aaaaa'::varchar(30); ---- false query T SELECT 'a'::text < 'aaaaa'::varchar(30); ---- true query T SELECT 'a'::text = 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::text > 'aaaaa '::varchar(30); ---- false query T SELECT 'a'::text < 'aaaaa '::varchar(30); ---- true query T SELECT 'a'::text = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::text > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a'::text < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a'::text = ''::varchar(30); ---- false query T SELECT 'a'::text > ''::varchar(30); ---- true query T SELECT 'a'::text < ''::varchar(30); ---- false query T SELECT 'a'::text = ' '::varchar(30); ---- false query T SELECT 'a'::text > ' '::varchar(30); ---- true query T SELECT 'a'::text < ' '::varchar(30); ---- false query T SELECT 'a '::text = 'a'::varchar(30); ---- false query T SELECT 'a '::text > 'a'::varchar(30); ---- true query T SELECT 'a '::text < 'a'::varchar(30); ---- false query T SELECT 'a '::text = 'a '::varchar(30); ---- true query T SELECT 'a '::text > 'a '::varchar(30); ---- false query T SELECT 'a '::text < 'a '::varchar(30); ---- false query T SELECT 'a '::text = 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::text > 'aaaaa'::varchar(30); ---- false query T SELECT 'a '::text < 'aaaaa'::varchar(30); ---- true query T SELECT 'a '::text = 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::text > 'aaaaa '::varchar(30); ---- false query T SELECT 'a '::text < 'aaaaa '::varchar(30); ---- true query T SELECT 'a '::text = 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::text > 'aaaaaa'::varchar(30); ---- false query T SELECT 'a '::text < 'aaaaaa'::varchar(30); ---- true query T SELECT 'a '::text = ''::varchar(30); ---- false query T SELECT 'a '::text > ''::varchar(30); ---- true query T SELECT 'a '::text < ''::varchar(30); ---- false query T SELECT 'a '::text = ' '::varchar(30); ---- false query T SELECT 'a '::text > ' '::varchar(30); ---- true query T SELECT 'a '::text < ' '::varchar(30); ---- false query T SELECT 'aaaaa'::text = 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::text > 'a'::varchar(30); ---- true query T SELECT 'aaaaa'::text < 'a'::varchar(30); ---- false query T SELECT 'aaaaa'::text = 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::text > 'a '::varchar(30); ---- true query T SELECT 'aaaaa'::text < 'a '::varchar(30); ---- false query T SELECT 'aaaaa'::text = 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::text > 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::text < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::text = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::text > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa'::text < 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa'::text = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::text > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa'::text < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa'::text = ''::varchar(30); ---- false query T SELECT 'aaaaa'::text > ''::varchar(30); ---- true query T SELECT 'aaaaa'::text < ''::varchar(30); ---- false query T SELECT 'aaaaa'::text = ' '::varchar(30); ---- false query T SELECT 'aaaaa'::text > ' '::varchar(30); ---- true query T SELECT 'aaaaa'::text < ' '::varchar(30); ---- false query T SELECT 'aaaaa '::text = 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::text > 'a'::varchar(30); ---- true query T SELECT 'aaaaa '::text < 'a'::varchar(30); ---- false query T SELECT 'aaaaa '::text = 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::text > 'a '::varchar(30); ---- true query T SELECT 'aaaaa '::text < 'a '::varchar(30); ---- false query T SELECT 'aaaaa '::text = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::text > 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::text < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::text = 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaa '::text > 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::text < 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaa '::text = 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::text > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaa '::text < 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaa '::text = ''::varchar(30); ---- false query T SELECT 'aaaaa '::text > ''::varchar(30); ---- true query T SELECT 'aaaaa '::text < ''::varchar(30); ---- false query T SELECT 'aaaaa '::text = ' '::varchar(30); ---- false query T SELECT 'aaaaa '::text > ' '::varchar(30); ---- true query T SELECT 'aaaaa '::text < ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::text = 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::text > 'a'::varchar(30); ---- true query T SELECT 'aaaaaa'::text < 'a'::varchar(30); ---- false query T SELECT 'aaaaaa'::text = 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::text > 'a '::varchar(30); ---- true query T SELECT 'aaaaaa'::text < 'a '::varchar(30); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::text = 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::text > 'aaaaa '::varchar(30); ---- true query T SELECT 'aaaaaa'::text < 'aaaaa '::varchar(30); ---- false query T SELECT 'aaaaaa'::text = 'aaaaaa'::varchar(30); ---- true query T SELECT 'aaaaaa'::text > 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::text < 'aaaaaa'::varchar(30); ---- false query T SELECT 'aaaaaa'::text = ''::varchar(30); ---- false query T SELECT 'aaaaaa'::text > ''::varchar(30); ---- true query T SELECT 'aaaaaa'::text < ''::varchar(30); ---- false query T SELECT 'aaaaaa'::text = ' '::varchar(30); ---- false query T SELECT 'aaaaaa'::text > ' '::varchar(30); ---- true query T SELECT 'aaaaaa'::text < ' '::varchar(30); ---- false query T SELECT ''::text = 'a'::varchar(30); ---- false query T SELECT ''::text > 'a'::varchar(30); ---- false query T SELECT ''::text < 'a'::varchar(30); ---- true query T SELECT ''::text = 'a '::varchar(30); ---- false query T SELECT ''::text > 'a '::varchar(30); ---- false query T SELECT ''::text < 'a '::varchar(30); ---- true query T SELECT ''::text = 'aaaaa'::varchar(30); ---- false query T SELECT ''::text > 'aaaaa'::varchar(30); ---- false query T SELECT ''::text < 'aaaaa'::varchar(30); ---- true query T SELECT ''::text = 'aaaaa '::varchar(30); ---- false query T SELECT ''::text > 'aaaaa '::varchar(30); ---- false query T SELECT ''::text < 'aaaaa '::varchar(30); ---- true query T SELECT ''::text = 'aaaaaa'::varchar(30); ---- false query T SELECT ''::text > 'aaaaaa'::varchar(30); ---- false query T SELECT ''::text < 'aaaaaa'::varchar(30); ---- true query T SELECT ''::text = ''::varchar(30); ---- true query T SELECT ''::text > ''::varchar(30); ---- false query T SELECT ''::text < ''::varchar(30); ---- false query T SELECT ''::text = ' '::varchar(30); ---- false query T SELECT ''::text > ' '::varchar(30); ---- false query T SELECT ''::text < ' '::varchar(30); ---- true query T SELECT ' '::text = 'a'::varchar(30); ---- false query T SELECT ' '::text > 'a'::varchar(30); ---- false query T SELECT ' '::text < 'a'::varchar(30); ---- true query T SELECT ' '::text = 'a '::varchar(30); ---- false query T SELECT ' '::text > 'a '::varchar(30); ---- false query T SELECT ' '::text < 'a '::varchar(30); ---- true query T SELECT ' '::text = 'aaaaa'::varchar(30); ---- false query T SELECT ' '::text > 'aaaaa'::varchar(30); ---- false query T SELECT ' '::text < 'aaaaa'::varchar(30); ---- true query T SELECT ' '::text = 'aaaaa '::varchar(30); ---- false query T SELECT ' '::text > 'aaaaa '::varchar(30); ---- false query T SELECT ' '::text < 'aaaaa '::varchar(30); ---- true query T SELECT ' '::text = 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::text > 'aaaaaa'::varchar(30); ---- false query T SELECT ' '::text < 'aaaaaa'::varchar(30); ---- true query T SELECT ' '::text = ''::varchar(30); ---- false query T SELECT ' '::text > ''::varchar(30); ---- true query T SELECT ' '::text < ''::varchar(30); ---- false query T SELECT ' '::text = ' '::varchar(30); ---- true query T SELECT ' '::text > ' '::varchar(30); ---- false query T SELECT ' '::text < ' '::varchar(30); ---- false query T SELECT 'a'::text = 'a'::text; ---- true query T SELECT 'a'::text > 'a'::text; ---- false query T SELECT 'a'::text < 'a'::text; ---- false query T SELECT 'a'::text = 'a '::text; ---- false query T SELECT 'a'::text > 'a '::text; ---- false query T SELECT 'a'::text < 'a '::text; ---- true query T SELECT 'a'::text = 'aaaaa'::text; ---- false query T SELECT 'a'::text > 'aaaaa'::text; ---- false query T SELECT 'a'::text < 'aaaaa'::text; ---- true query T SELECT 'a'::text = 'aaaaa '::text; ---- false query T SELECT 'a'::text > 'aaaaa '::text; ---- false query T SELECT 'a'::text < 'aaaaa '::text; ---- true query T SELECT 'a'::text = 'aaaaaa'::text; ---- false query T SELECT 'a'::text > 'aaaaaa'::text; ---- false query T SELECT 'a'::text < 'aaaaaa'::text; ---- true query T SELECT 'a'::text = ''::text; ---- false query T SELECT 'a'::text > ''::text; ---- true query T SELECT 'a'::text < ''::text; ---- false query T SELECT 'a'::text = ' '::text; ---- false query T SELECT 'a'::text > ' '::text; ---- true query T SELECT 'a'::text < ' '::text; ---- false query T SELECT 'a '::text = 'a'::text; ---- false query T SELECT 'a '::text > 'a'::text; ---- true query T SELECT 'a '::text < 'a'::text; ---- false query T SELECT 'a '::text = 'a '::text; ---- true query T SELECT 'a '::text > 'a '::text; ---- false query T SELECT 'a '::text < 'a '::text; ---- false query T SELECT 'a '::text = 'aaaaa'::text; ---- false query T SELECT 'a '::text > 'aaaaa'::text; ---- false query T SELECT 'a '::text < 'aaaaa'::text; ---- true query T SELECT 'a '::text = 'aaaaa '::text; ---- false query T SELECT 'a '::text > 'aaaaa '::text; ---- false query T SELECT 'a '::text < 'aaaaa '::text; ---- true query T SELECT 'a '::text = 'aaaaaa'::text; ---- false query T SELECT 'a '::text > 'aaaaaa'::text; ---- false query T SELECT 'a '::text < 'aaaaaa'::text; ---- true query T SELECT 'a '::text = ''::text; ---- false query T SELECT 'a '::text > ''::text; ---- true query T SELECT 'a '::text < ''::text; ---- false query T SELECT 'a '::text = ' '::text; ---- false query T SELECT 'a '::text > ' '::text; ---- true query T SELECT 'a '::text < ' '::text; ---- false query T SELECT 'aaaaa'::text = 'a'::text; ---- false query T SELECT 'aaaaa'::text > 'a'::text; ---- true query T SELECT 'aaaaa'::text < 'a'::text; ---- false query T SELECT 'aaaaa'::text = 'a '::text; ---- false query T SELECT 'aaaaa'::text > 'a '::text; ---- true query T SELECT 'aaaaa'::text < 'a '::text; ---- false query T SELECT 'aaaaa'::text = 'aaaaa'::text; ---- true query T SELECT 'aaaaa'::text > 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::text < 'aaaaa'::text; ---- false query T SELECT 'aaaaa'::text = 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::text > 'aaaaa '::text; ---- false query T SELECT 'aaaaa'::text < 'aaaaa '::text; ---- true query T SELECT 'aaaaa'::text = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::text > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa'::text < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa'::text = ''::text; ---- false query T SELECT 'aaaaa'::text > ''::text; ---- true query T SELECT 'aaaaa'::text < ''::text; ---- false query T SELECT 'aaaaa'::text = ' '::text; ---- false query T SELECT 'aaaaa'::text > ' '::text; ---- true query T SELECT 'aaaaa'::text < ' '::text; ---- false query T SELECT 'aaaaa '::text = 'a'::text; ---- false query T SELECT 'aaaaa '::text > 'a'::text; ---- true query T SELECT 'aaaaa '::text < 'a'::text; ---- false query T SELECT 'aaaaa '::text = 'a '::text; ---- false query T SELECT 'aaaaa '::text > 'a '::text; ---- true query T SELECT 'aaaaa '::text < 'a '::text; ---- false query T SELECT 'aaaaa '::text = 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::text > 'aaaaa'::text; ---- true query T SELECT 'aaaaa '::text < 'aaaaa'::text; ---- false query T SELECT 'aaaaa '::text = 'aaaaa '::text; ---- true query T SELECT 'aaaaa '::text > 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::text < 'aaaaa '::text; ---- false query T SELECT 'aaaaa '::text = 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::text > 'aaaaaa'::text; ---- false query T SELECT 'aaaaa '::text < 'aaaaaa'::text; ---- true query T SELECT 'aaaaa '::text = ''::text; ---- false query T SELECT 'aaaaa '::text > ''::text; ---- true query T SELECT 'aaaaa '::text < ''::text; ---- false query T SELECT 'aaaaa '::text = ' '::text; ---- false query T SELECT 'aaaaa '::text > ' '::text; ---- true query T SELECT 'aaaaa '::text < ' '::text; ---- false query T SELECT 'aaaaaa'::text = 'a'::text; ---- false query T SELECT 'aaaaaa'::text > 'a'::text; ---- true query T SELECT 'aaaaaa'::text < 'a'::text; ---- false query T SELECT 'aaaaaa'::text = 'a '::text; ---- false query T SELECT 'aaaaaa'::text > 'a '::text; ---- true query T SELECT 'aaaaaa'::text < 'a '::text; ---- false query T SELECT 'aaaaaa'::text = 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::text > 'aaaaa'::text; ---- true query T SELECT 'aaaaaa'::text < 'aaaaa'::text; ---- false query T SELECT 'aaaaaa'::text = 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::text > 'aaaaa '::text; ---- true query T SELECT 'aaaaaa'::text < 'aaaaa '::text; ---- false query T SELECT 'aaaaaa'::text = 'aaaaaa'::text; ---- true query T SELECT 'aaaaaa'::text > 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::text < 'aaaaaa'::text; ---- false query T SELECT 'aaaaaa'::text = ''::text; ---- false query T SELECT 'aaaaaa'::text > ''::text; ---- true query T SELECT 'aaaaaa'::text < ''::text; ---- false query T SELECT 'aaaaaa'::text = ' '::text; ---- false query T SELECT 'aaaaaa'::text > ' '::text; ---- true query T SELECT 'aaaaaa'::text < ' '::text; ---- false query T SELECT ''::text = 'a'::text; ---- false query T SELECT ''::text > 'a'::text; ---- false query T SELECT ''::text < 'a'::text; ---- true query T SELECT ''::text = 'a '::text; ---- false query T SELECT ''::text > 'a '::text; ---- false query T SELECT ''::text < 'a '::text; ---- true query T SELECT ''::text = 'aaaaa'::text; ---- false query T SELECT ''::text > 'aaaaa'::text; ---- false query T SELECT ''::text < 'aaaaa'::text; ---- true query T SELECT ''::text = 'aaaaa '::text; ---- false query T SELECT ''::text > 'aaaaa '::text; ---- false query T SELECT ''::text < 'aaaaa '::text; ---- true query T SELECT ''::text = 'aaaaaa'::text; ---- false query T SELECT ''::text > 'aaaaaa'::text; ---- false query T SELECT ''::text < 'aaaaaa'::text; ---- true query T SELECT ''::text = ''::text; ---- true query T SELECT ''::text > ''::text; ---- false query T SELECT ''::text < ''::text; ---- false query T SELECT ''::text = ' '::text; ---- false query T SELECT ''::text > ' '::text; ---- false query T SELECT ''::text < ' '::text; ---- true query T SELECT ' '::text = 'a'::text; ---- false query T SELECT ' '::text > 'a'::text; ---- false query T SELECT ' '::text < 'a'::text; ---- true query T SELECT ' '::text = 'a '::text; ---- false query T SELECT ' '::text > 'a '::text; ---- false query T SELECT ' '::text < 'a '::text; ---- true query T SELECT ' '::text = 'aaaaa'::text; ---- false query T SELECT ' '::text > 'aaaaa'::text; ---- false query T SELECT ' '::text < 'aaaaa'::text; ---- true query T SELECT ' '::text = 'aaaaa '::text; ---- false query T SELECT ' '::text > 'aaaaa '::text; ---- false query T SELECT ' '::text < 'aaaaa '::text; ---- true query T SELECT ' '::text = 'aaaaaa'::text; ---- false query T SELECT ' '::text > 'aaaaaa'::text; ---- false query T SELECT ' '::text < 'aaaaaa'::text; ---- true query T SELECT ' '::text = ''::text; ---- false query T SELECT ' '::text > ''::text; ---- true query T SELECT ' '::text < ''::text; ---- false query T SELECT ' '::text = ' '::text; ---- true query T SELECT ' '::text > ' '::text; ---- false query T SELECT ' '::text < ' '::text; ---- false