Re: From CROSSTAB: One Column data with Two results columns

From: Andreas Wagner <thewand(at)web(dot)de>
To: M Sarwar <sarwarmd02(at)outlook(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: From CROSSTAB: One Column data with Two results columns
Date: 2024-04-15 09:03:41
Message-ID: eabe02b475c34361babc34d986aef1f76bbfa7ba.camel@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello!

Am Sonntag, dem 14.04.2024 um 20:54 +0000 schrieb M Sarwar:
> Hi,
> I am working CROSSTAB functionality to generate the reports in the
> CSV format.
>  
> Now I have stage where I need to generate 2 result sets  for the same
> 1 column data.

Something like "CREATE VIEW"? The documentation has some useful
examples: https://www.postgresql.org/docs/current/sql-createview.html

"CREATE PROCEDURE" and "CREATE FUNCTION" are rarely covered by
tutorials, so I mention them. They can be used in a similar manner.

For CSV, I'm the wrong person. I'd code it in C/C++.

Regards,
Andreas Wagner

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oracle People 2024-04-15 09:30:04 ERROR could not read block xxx in file, read only 0 of 8192 bytes
Previous Message Sandeep Sivashankaran 2024-04-15 07:09:25 Postgresql integration with Microsoft AD