GROUP BY PERIOD: Select * support
Created by: Piiit
Do we need the following to work?
create table e
(
a char,
b char,
t int4range
);
insert into e values
('A','A','[1,7)'),
('A','B','[3,18)'),
('B','A','[1,25)');
select *, count(*) from e group by period with (t) a order by a,t;
Currently we have the following error:
psql:unibz/tests/test-temporalgroupby.sql:18: ERROR: column "e.b" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select *, count(*) from e group by period with (t) a order b...
^