Search Postgresql Archives
How to set alias data type?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: How to set alias data type?
From
: Shaozhong SHI <shishaozhong@xxxxxxxxx>
Date
: Wed, 24 Nov 2021 13:57:06 +0000
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: How to set alias data type?
From:
hubert depesz lubaczewski
Prev by Date:
get last timestamp of table ddl
Next by Date:
Re: get last timestamp of table ddl
Previous by thread:
get last timestamp of table ddl
Next by thread:
Re: How to set alias data type?
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]