select 'Total' as Total generate result that set Total as a column namewith unknown type
When trying to castselect 'Total' as Total:: text
It simply does not work.
Regards,
David