Message-ID: <26da2e223102a181b0fdb41800ceba3fedd9bda6.camel@web.de>
Subject: Re: From CROSSTAB: One Column data with Two results columns
From: Andreas Wagner <thewand@web.de>
To: M Sarwar <sarwarmd02@outlook.com>, "pgsql-admin@lists.postgresql.org"
	 <pgsql-admin@lists.postgresql.org>
Date: Mon, 15 Apr 2024 23:48:43 +0200
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>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.0 
MIME-Version: 1.0
UI-OutboundReport: notjunk:1;M01:P0:Wi28GRCFHRA=;cSVPtgeMgfn7c4nyUnHh12IF8yp
 IlsR+VclhiKMznXg25E1Ng9Y97yat5UVrLhUzefnTdX6q1nEZT8dHvIxJ3LHZgtjaHAr66Sfp
 o+3zyWkSewW3D+2biYWSw3aOibo+vmGWqu8OuZ8sAdGMqwZ+KDZ9A9OQ/+ASdF0A3ErkNX6Kg
 48Qcg7fCYe1GODTgav8ywEv5XP4r/hjJcuy4J7xX5lg8xruZk2iGqKCAV6Z78xqvmUDuG3Nls
 dRYf8XxjOY0FOfgYy6YilObq5wvBgpBN55bjAndilTNLS4+1pL8scmWYOOFbxdLuye8WM/cJo
 Lm34rOuVRyrKMB5T824AU+kPHXvM+05Q5zI+a469yPJa/Ny8wcKuYb4k84X9Q+RZt0JzwSHRO
 RZYdtVSzMt2edZOuTTEpPFfkMQGNn1q24L7bJ3cI8Q44RW30BoBrlhffbcIR4tcptj4NnqD3/
 Ari4eiYEXFyomYzw08aP7qSx+jeIbkPvjKLrE5UPxAs4lPEZr1i20ytHoveEeTql1OpdeS5cA
 NZOixKKhUSGSgrAQhb1NIvalMvW7qlKl6skVliKOR2K2CEQB9QT8MHopL5OlHjftdMomR+oXO
 40HdXXjg51nj5nEDuJxbMDsnxU1PbH/f5cP8Z4n+1LyCwVsvg4bCYjTZ0bycyNid2KoUUybhp
 AvuBRzJe6pHhYgIDKN3pa0TxZSu2c+4BlLdy5aO38bVP6DfyeIlCCa2sAUrm0qztxTzZbjZpt
 fhlZzAhik4xx8XGyoXRyt6CAMGgYsp/Y513HE9LKIqqomg7uaTbc1zA05vxhdp5xwGs+ZWtUp
 j0/77IXg3277/kg81aQrB9ViKfqzbRIUKEKkiVKVJvKdY=
Archived-At: 
 <https://www.postgresql.org/message-id/26da2e223102a181b0fdb41800ceba3fedd9bda6.camel%40web.de>
Precedence: bulk

Hello Mr. Sarwar!

Am Montag, dem 15.04.2024 um 19:42 +0000 schrieb M Sarwar:
>=20
> =C2=A0
> Hello Mr. Andreas,
> =C2=A0( Just correcting=C2=A0 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 (=3D given name) last name (=3D 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.

>=20
> You are using my name perfectly.=C2=A0
> In the CROSSTAB clause, there are 3 sections.
> =C2=A0=C2=A0=C2=A01.=20
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Row columns
> =C2=A0=C2=A0=C2=A02.=20
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Category column
> =C2=A0=C2=A0=C2=A03.=20
> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0Data / 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.