Error reporting: Normalization with range-types where no ranges are given!
Created by: Piiit
SELECT *
FROM
( e normalize e x using(a) with (ts, te) ) e
gives
ERROR: function pg_catalog.lower(integer) does not exist
SQL Status:42883
HINT:No function matches the given name and argument types. You might need to add explicit type casts.
...when the table e has no range types for the columns ts and te defined. The error should be something like:
ERROR: First temporal bound is not a range type.
HINT: Specify 4 separate columns for the temporal boundaries for the relations 'e' and 'x', or two range-typed columns
SELECT * FROM ( e normalize e x using(a) with (ts, te) ) e
^
Contents:
# table e;
x | a | ts | te
---+---+----+----
A | A | 1 | 7
A | B | 3 | 18
B | A | 1 | 25
(3 rows)