Can not use temporal primitives with a WITH()SELECT... clause
Created by: Piiit
A=# table r01;
a | b | ts | te
---+---+----+----
a | B | 1 | 7
b | B | 3 | 9
c | G | 8 | 10
(3 rows)
A=# \d r01;
Table "public.r01"
Column | Type | Modifiers
--------+--------------+-----------
a | character(1) |
b | character(1) |
ts | integer |
te | integer |
A=# with x as (select a, b, te::varchar, ts::varchar from r01)
select * from (x normalize x z using() with(ts,te,ts,te)) c
;
ERROR: unrecognized node type: 140
A=# with x as (select a, b, te::varchar, ts::varchar from r01)
select * from (x normalize x z using() with(ts,te,ts,te)) c;
ERROR: unrecognized node type: 140
A=# SET log_error_verbosity = verbose;
SET
A=# with x as (select a, b, te::varchar, ts::varchar from r01)
select * from (x normalize x z using() with(ts,te,ts,te)) c;
ERROR: unrecognized node type: 140