Constructing colum name as alias

Поиск
Список
Период
Сортировка
От aditya desai
Тема Constructing colum name as alias
Дата
Msg-id CAN0SRDH0DhD=WUCbyZ6mG9XGbEyuTaTvaMqoBZc_++7uNxpvrg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Constructing colum name as alias
Re: Constructing colum name as alias
Список pgsql-sql
Дерево обсуждения
Hi,
I want to construct column name alias by using different queries. E.g. below.

postgres=# Select ('Status as on '||date_part('day', (SELECT current_timestamp))||'th '||TO_CHAR(current_timestamp, 'Mon'))
postgres-# ;
       ?column?
-----------------------
 Status as on 11th Nov

" Status as on 11th Nov" should be my column name in a query.

SELECT JoiningDate as "Status as on 11th Nov" from empdetails;

How can I achieve this?

Regards,
Aditya.

В списке pgsql-sql по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to assign variable in array value inside function proc.
Следующее
От: "Torsten Grust"
Дата:
Сообщение: Re: Constructing colum name as alias