How to set alias data type?
Started by Shaozhong SHIover 4 years ago2 messagesgeneral
select 'Total' as Total generate result that set Total as a column name
with unknown type
When trying to cast
select 'Total' as Total:: text
It simply does not work.
Regards,
David
Re: How to set alias data type?
On Wed, Nov 24, 2021 at 01:57:06PM +0000, Shaozhong SHI wrote:
select 'Total' as Total generate result that set Total as a column name
with unknown typeWhen trying to cast
select 'Total' as Total:: text
You need to cast value, and not name.
select 'Total'::text as Total;
Best regards,
depesz