|
Hello Andreas,
Using a function, I am generating CROSSTAB SQL and the number of columns will vary for each execution. With that, it is extremely difficult to use view on this task.
Thanks,
Sarwar
From: Andreas Wagner <thewand@xxxxxx>
Sent: Monday, April 15, 2024 5:03 AM To: M Sarwar <sarwarmd02@xxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> Subject: Re: From CROSSTAB: One Column data with Two results columns 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://na01.safelinks.protection.outlook.com/?url=""> "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 |
