From: Andreas Wagner <thewand@web.de>
To: M Sarwar <sarwarmd02@outlook.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: From CROSSTAB: One Column data with Two results columns
Date: Mon, 15 Apr 2024 23:48:43 +0200
Message-ID: <26da2e223102a181b0fdb41800ceba3fedd9bda6.camel@web.de> (raw)
In-Reply-To: <DM4PR19MB5978DB4374B1D9245124EE38D3092@DM4PR19MB5978.namprd19.prod.outlook.com>
References: <PH2P110MB0922542FEBDBD433903505A9FF0AA@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
<DM4PR19MB59785E2044FF7F30410FDAABD30A2@DM4PR19MB5978.namprd19.prod.outlook.com>
<DM4PR19MB5978E1148EDA0DB8AA8DED7ED30A2@DM4PR19MB5978.namprd19.prod.outlook.com>
<DM4PR19MB59788EAD138EA457D4FE6A9BD30A2@DM4PR19MB5978.namprd19.prod.outlook.com>
<eabe02b475c34361babc34d986aef1f76bbfa7ba.camel@web.de>
<DM4PR19MB5978C5982BF97D6DE105158AD3092@DM4PR19MB5978.namprd19.prod.outlook.com>
<c1724e227b02088dddacb6db20e9e7b083267786.camel@web.de>
<DM4PR19MB5978A7ED6F0D1574250939D7D3092@DM4PR19MB5978.namprd19.prod.outlook.com>
<DM4PR19MB5978DB4374B1D9245124EE38D3092@DM4PR19MB5978.namprd19.prod.outlook.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: thewand@web.de, sarwarmd02@outlook.com, pgsql-admin@lists.postgresql.org
Subject: Re: From CROSSTAB: One Column data with Two results columns
In-Reply-To: <26da2e223102a181b0fdb41800ceba3fedd9bda6.camel@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox