-- bigbase36 conversion should encode integer; SELECT 120::bigint::bigbase36; -- bigbase36 conversion should decode text; SELECT '3c'::bigbase36::bigint; -- bigbase36 conversion should error to big values; SELECT '3caaaaaaaaaaaaa'::bigbase36::bigint; -- bigbase36 conversion should cast big bigbase36 values; SELECT '1y2p0ij32e8e7'::bigbase36::bigint; -- bigbase36 conversion should cast big bigint values; SELECT 9223372036854775807::bigbase36; -- bigbase36 conversion should error to big values; SELECT '1y2p0ij32e8e8'::bigbase36::bigint; -- bigbase36 conversion should error invalid values; SELECT '3&'::bigbase36::bigint; -- bigbase36 comparison should compare using >; SELECT 'a'::bigbase36 > 'b'::bigbase36; -- bigbase36 comparison should compare using <; SELECT 'a'::bigbase36 < 'b'::bigbase36; -- bigbase36 negative values should convert from base36; SELECT '-zik0zj'::bigbase36::bigint; -- bigbase36 negative values should convert from ints; SELECT '-2147483647'::bigint::bigbase36;