May we have an example?
On Thu, Nov 11, 2021, 08:19 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:
> On Thursday, November 11, 2021, aditya desai <admad123(at)gmail(dot)com> wrote:
>
>>
>> " 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?
>>
>
> Dynamic SQL and two independent queries. One to get the column name.
> Then a dynamic one (say using pl/pgsql) that uses that name.
>
> David J.
>
>