Re: From CROSSTAB: One Column data with Two results columns - Mailing list pgsql-admin
Hello Ms. Andreas,
You are using my name perfectly.
In the CROSSTAB clause, there are 3 sections.
- Row columns
- Category column
- Data / Results columns
CROSSTAB provides option to fetch just 1 column while using CROSSTAB in normal circumstances.
My question is 'is there anyway that I can fetch 2 columns?'.
I am sharing the pictorial diagram where I need to fetch 2 columns data / results for the same category columns ( TEST1P1, TEST1P2, TEST1P3, TEST1P4 ).
Thank you,
Sarwar
From: Andreas Wagner <thewand@web.de>
Sent: Monday, April 15, 2024 1:41 PM
To: M Sarwar <sarwarmd02@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: From CROSSTAB: One Column data with Two results columns
Sent: Monday, April 15, 2024 1:41 PM
To: M Sarwar <sarwarmd02@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: From CROSSTAB: One Column data with Two results columns
Hello Mr. Sarwar!
I'm not certain about first and last names in foreign countries, so my
apologies if it's your first name.
Am Montag, dem 15.04.2024 um 12:25 +0000 schrieb M Sarwar:
>
> 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.
I'm still not sure whether I understand your question. You look for a
way to produce statements like
SELECT test1p1.data, test1p2.data, test1p3.data,
f(test1p1.data), f(test1p2.data), f(test1p3.data)
FROM test1p1, test1p2, test1p3;
programmatically? ("f()" is a user-defined function deriving the left
values on the sample-picture to the right values.)
In case using multiple tables is new to you, have a look at the "JOIN"-
statement.
Regards,
Andreas Wagner
I'm not certain about first and last names in foreign countries, so my
apologies if it's your first name.
Am Montag, dem 15.04.2024 um 12:25 +0000 schrieb M Sarwar:
>
> 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.
I'm still not sure whether I understand your question. You look for a
way to produce statements like
SELECT test1p1.data, test1p2.data, test1p3.data,
f(test1p1.data), f(test1p2.data), f(test1p3.data)
FROM test1p1, test1p2, test1p3;
programmatically? ("f()" is a user-defined function deriving the left
values on the sample-picture to the right values.)
In case using multiple tables is new to you, have a look at the "JOIN"-
statement.
Regards,
Andreas Wagner
Attachment
pgsql-admin by date: