SET OPERATIONS: CTEs do not work as input queries
Created by: Piiit
ERROR: relation "e" does not exist at character 121
STATEMENT:
WITH
e AS
(
select a,b,lower(t) ts1, upper(t) te1 from e
),
f AS
(
select a,b,lower(t) ts2, upper(t) te2 from f
)
table e
UNION PERIOD WITH (ts1,te1)
table f
order by 1,2,3,4;