Home > mailing lists

How to set alias data type? - Mailing list pgsql-general

From	Shaozhong SHI
Subject	How to set alias data type?
Date	November 24, 2021 16:57:06
Msg-id	CA+i5JwbTxucfSepExn4JOSSWsXwaD=3bZVgh__u5O3WjJdNWSQ@mail.gmail.com Whole thread Raw
Responses	Re: How to set alias data type? (hubert depesz lubaczewski <depesz@depesz.com>)
List	pgsql-general

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

From: Luca Ferrari
Date: 24 November 2021, 16:53:24
Subject: get last timestamp of table ddl

From: hubert depesz lubaczewski
Date: 24 November 2021, 17:09:58
Subject: Re: get last timestamp of table ddl