Hello Mr. Sarwar! Am Montag, dem 15.04.2024 um 19:42 +0000 schrieb M Sarwar: > > > Hello Mr. Andreas, > ( Just correcting the title / Sorry for my bad. ) Thanks for staying polite - even friendly - with me! For your benefit in intercultural communication, I remark, in Germany, two ways of writing down a name are common: 1. First name (= given name) last name (= surname or name of the family), in my case, Andreas Wagner 2. Last name, first name. In my case: Wagner, Andreas. I'm quite sure, in the first case, callign with the first name is percieved ok while in the second case, calling with the last name is preferred. > > You are using my name perfectly. > In the CROSSTAB clause, there are 3 sections. > 1. > Row columns > 2. > Category column > 3. > Data / Results columns This is why I'm happy to see you still patient; I never ran accross the Crosstab() function before. I read the documentation a few minutes ago and tried to play with Crosstab() but I seem to have unclear issues with my computer. ("postgresql-server", openSUSE package doens't install a service, no posgres-service running but the postgres user exists. On the ARM-SBC, postgres is already installed in version 15 and I seem to have issues with the syntax.) > 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 ). I'm sorry, I can't answer your question. Due to the issues with my openSUSE (Tumbleweed) install I consider leaving. I have a terrible amount of hacking/remote sabotage, here and this gives me the assumption, "they" want me to leave this community. Regards, Andreas Wagner, presumably head of Wagner Group (or why the hell am I sabotaged by that amount?! Even C-code doen't behave as I tell it to!) PS Mails regarding my current schizo-boost please to me alone. The boost will be over, soon, when I stop to care, why no postgres-service was running after a regular "zypper install postgresql-server". My apologies.