Message-ID: <c1724e227b02088dddacb6db20e9e7b083267786.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 19:41:47 +0200
In-Reply-To: 
 <DM4PR19MB5978C5982BF97D6DE105158AD3092@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>
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:86maBpZGWwI=;nJov52HPVW/DPJ5fFYE89J5CDpi
 plEuMrp/UQ5wOg8UjoVXesqcxhVFxPuteZLtH8BLsOOdI6gHQkUdra1LiEkGhwGEPqTkpyXAh
 84GvnHE9kcXjiWM2mr53xRG7HVGEEcgvc8MBukcfD/MTbJ9DXdqidBnqjCvixtaXeLDyAbzkZ
 eGLouOtrnewGNpdytb5vsoiJ83Heoq6pJiIV4GcZ8Cfpa5oDJeVRDx6GNftRR93L8NMCWpMDc
 RooOHGj9dGh6PFIdkI+OqOKfwWzARXunXkWiJuhB1FwabGopuWUClBF1Q8JITNjIXJuWerp6K
 OLeI+maU/X17b9qqOii5pgzhXj3/q58Pzz9Dhyiuqkw1HLDWcbqZqsn8vImzFbSg4ajHuVGk+
 ZKp9Ff0HoHCZryCv287FqfhMONJ/jd4orDb/jRLCTZJVZGCgt+kXpXWVPM9aS0KCdDb6ec+VH
 CZCuWBp35zxTMBHHfXM3j/6Q9dx7l0B1T17aJGU4tiFryVJywwfvzPMpVaBVth2qEDbA3jc7F
 iGznJuBRc61QJhXlNrupeiyEWBJ3sr7nei1MYaUAHa5S5alhI/+9dBCQOjprPLN61AYoEHre5
 fOBFQc/Zyz6YMuyql7sI50P21ypKV35CCZsbEgoX2JfvNz4K2WqofWlbh22FANrPIVRbZWIX3
 WJHn/mDEbZsxPztnZrTSeyyeAgIfW1jRTwL+ZQ7BTDPuek4FM79KznVJOo4YYjRQdVn5sNrPz
 PDbcHvtn+57W15hrHlJxNCUIE9i369XLrbHZ0MYlDypFx2E9qRkiL+xrPSDlNGCEsj/E6UaRy
 t432xb2dTLOPt8Bcke82kN+p7VdlwZUnxvYn42lg0i3iM=
Archived-At: 
 <https://www.postgresql.org/message-id/c1724e227b02088dddacb6db20e9e7b083267786.camel%40web.de>
Precedence: bulk

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:
>=20
> Hello Andreas,
> Using a function, I am generating=C2=A0 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