Can not use temporal primitives with varchars as temporal bounds
Created by: Piiit
A=# select * from
((select a, b, te::varchar, ts::varchar from r01)x
normalize
(select a, b, te::varchar, ts::varchar from r01) z using() with(ts,te,ts,te)) c;
ERROR: could not determine which collation to use for string comparison
HINT: Use the COLLATE clause to set the collation explicitly.
----
A=# select * from
((select a, b, te::varchar, ts::varchar from r01)x
align
(select a, b, te::varchar, ts::varchar from r01) z on true with(ts,te,ts,te)) c;
ERROR: could not determine which collation to use for string comparison
HINT: Use the COLLATE clause to set the collation explicitly.