User-Agent: Cyrus-JMAP/3.5.0-alpha0-1371-g2296cc3491-fm-20211109.003-g2296cc34
Mime-Version: 1.0
Message-Id: <b2f18b45-c908-4c57-9a52-5bbc3dceed03@www.fastmail.com>
In-Reply-To: 
 <CAN0SRDH0DhD=WUCbyZ6mG9XGbEyuTaTvaMqoBZc_++7uNxpvrg@mail.gmail.com>
References: 
 <CAN0SRDH0DhD=WUCbyZ6mG9XGbEyuTaTvaMqoBZc_++7uNxpvrg@mail.gmail.com>
Date: Thu, 11 Nov 2021 12:10:31 +0100
From: "Torsten Grust" <teggy@fastmail.com>
To: "aditya desai" <admad123@gmail.com>,
 pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: Constructing colum name as alias
Content-Type: multipart/alternative;
 boundary=38bff7d6b671407cba1fe2234d7dbeda
Archived-At: 
 <https://www.postgresql.org/message-id/b2f18b45-c908-4c57-9a52-5bbc3dceed03%40www.fastmail.com>
Precedence: bulk

--38bff7d6b671407cba1fe2234d7dbeda
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi,

since column names (or table names) are not first-class values in SQL, c=
omputing such names at query runtime is impossible.

Best wishes, =20
   =E2=80=94Torsten

On Thu, Nov 11, 2021, at 08:46, aditya desai wrote:
> Hi,
> I want to construct column name alias by using different queries. E.g.=
 below.
>=20
> postgres=3D# Select ('Status as on '||date_part('day', (SELECT current=
_timestamp))||'th '||TO_CHAR(current_timestamp, 'Mon'))
> postgres-# ;
>        ?column?
> -----------------------
>  Status as on 11th Nov
>=20
> " Status as on 11th Nov" should be my column name in a query.
>=20
> SELECT JoiningDate as "Status as on 11th Nov" from empdetails;
>=20
> How can I achieve this?
>=20
> Regards,
> Aditya.
>=20

--
| Torsten Grust
| teggy@fastmail.com


--38bff7d6b671407cba1fe2234d7dbeda
Content-Type: text/html;charset=utf-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso=
Normal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi,<br></div><d=
iv><br></div><div>since column names (or table names) are not first-clas=
s values in SQL, computing such names at query runtime is impossible.<br=
></div><div><br></div><div>Best wishes, &nbsp;</div><div>&nbsp; &nbsp;=E2=
=80=94Torsten<br></div><div><br></div><div>On Thu, Nov 11, 2021, at 08:4=
6, aditya desai wrote:<br></div><blockquote type=3D"cite" id=3D"qt" styl=
e=3D""><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"lt=
r"><div dir=3D"ltr"><div>Hi,<br></div><div>I want to construct column na=
me alias by using different queries. E.g. below.<br></div><div><br></div=
><div><div>postgres=3D# Select ('Status as on '||date_part('day', (SELEC=
T current_timestamp))||'th '||TO_CHAR(current_timestamp, 'Mon'))<br></di=
v><div>postgres-# ;<br></div><div>&nbsp; &nbsp; &nbsp; &nbsp;?column?<br=
></div><div>-----------------------<br></div><div>&nbsp;Status as on 11t=
h Nov<br></div></div><div><br></div><div>" Status as on 11th Nov" should=
 be my column name in a query.<br></div><div><br></div><div>SELECT Joini=
ngDate as "Status as on 11th Nov" from empdetails;<br></div><div><br></d=
iv><div>How can I achieve&nbsp;this?<br></div><div><br></div><div>Regard=
s,<br></div><div>Aditya.<br></div><div><br></div></div></div></div></div=
></div></blockquote><div><br></div><div id=3D"sig115172376"><div class=3D=
"signature"><span class=3D"font" style=3D"font-family:menlo, consolas, m=
onospace, sans-serif;">--</span><span class=3D"font" style=3D"font-famil=
y:menlo, consolas, monospace, sans-serif;"></span><br></div><div class=3D=
"signature"><span class=3D"font" style=3D"font-family:menlo, consolas, m=
onospace, sans-serif;">| Torsten Grust</span><span class=3D"font" style=3D=
"font-family:menlo, consolas, monospace, sans-serif;"></span><br></div><=
div class=3D"signature"><span class=3D"font" style=3D"font-family:menlo,=
 consolas, monospace, sans-serif;">| </span><a href=3D"mailto:teggy@fast=
mail.com"><span class=3D"font" style=3D"font-family:menlo, consolas, mon=
ospace, sans-serif;">teggy@fastmail.com</span></a><span class=3D"font" s=
tyle=3D"font-family:menlo, consolas, monospace, sans-serif;"></span><br>=
</div><div class=3D"signature"><br></div></div><div><br></div></body></h=
tml>
--38bff7d6b671407cba1fe2234d7dbeda--