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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Hello Ms. Andreas,

You are using my name perfectly. 
In the CROSSTAB clause, there are 3 sections.
  1. Row columns
  2. Category column
  3. 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,

From: Andreas Wagner <thewand@xxxxxx>
Sent: Monday, April 15, 2024 1:41 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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

        f(, f(, f(
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"-

Andreas Wagner

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux