PG testing routine for temporal primitives is not complete

[Piiit]

All major test cases have been added, we consider the rest as future work.

The following test cases are still missing for the PRIMITIVE TEST:

• test-ambiguous-columns.sql
• test-indexes.sql
• test-subselects-and-aliases.sql

NaN for floats is not checked yet. It should produce an ERROR, but currently it is treated like a regular number.
We remove it from the test for now.

INSERT INTO tpg_table12 VALUES
(0, 1.0, 'NaN'), 
(1, 'NaN', 2.0);

-- Data types: Double precision with "NaN" (ERROR expected, not implemented yet)
SELECT a, ts, te FROM (
    tpg_table12 t1 ALIGN tpg_table12 t2
        ON TRUE 
        WITH (ts, te, ts, te)
    ) x;

-- Data types: Double precision with "NaN" (ERROR expected, not implemented yet)
SELECT a, ts, te FROM (
    tpg_table12 t1 NORMALIZE tpg_table12 t2
        ON TRUE
        WITH (ts, te, ts, te)
    ) x;