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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/c4fc6cb4-98c8-4fc1-b5c1-1ec6042b87ed%40googlegroups.com.
