I have a function datelist(startDate,endDate) returning a ResultSet that
containes 2 columns firstDay,lastDay.
select * from datelist('2019-01-01','2019-03-01') as cal
This works well, returning
firstDay lastDay
---------- ----------
2019-01-01 2019-01-31
2019-02-01 2019-02-28
2019-03-01 2019-03-31
The problem comes if I want to use any of the fields for example:
select cal.firstDay from from datelist('2019-01-01','2019-03-01') as cal
It fails saying cal.firstDate does not exists. Is there a way to use alias
on functions returning resultsets, or is this a bug?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/c4fc6cb4-98c8-4fc1-b5c1-1ec6042b87ed%40googlegroups.com.
