Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwIFm-000oZa-7Q for pgsql-admin@arkaria.postgresql.org; Mon, 15 Apr 2024 09:03:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rwIFk-00BohO-PR for pgsql-admin@arkaria.postgresql.org; Mon, 15 Apr 2024 09:03:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwIFk-00BohG-B4 for pgsql-admin@lists.postgresql.org; Mon, 15 Apr 2024 09:03:52 +0000 Received: from mout.web.de ([212.227.15.3]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwIFe-002wCV-6b for pgsql-admin@lists.postgresql.org; Mon, 15 Apr 2024 09:03:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=web.de; s=s29768273; t=1713171822; x=1713776622; i=thewand@web.de; bh=1kLSM4P62eJ3zbbK/5F26Bk618qLahkJnYECuBIbJoQ=; h=X-UI-Sender-Class:Message-ID:Subject:From:To:Date:In-Reply-To: References:Content-Type:Content-Transfer-Encoding:MIME-Version:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=A6iYqkyEN6pk0OdpODTW/jKB5Fkq6Vip2E6Cx9V8XDMo5LSs6bZ2stxjETjzQE9q GvHuFprGlgOkn6E8bdaIOaGBFXJjel2GcrkjaHD9/fMp7N5aINAsFryIj0hLjYD6L QyBJ2HNqp5E5J9E4RYuE9lPvm1nFh2jhZ1g9yV8FBhyopfExMgbx77tFqxQ3eelOH JVW0+rmr0bJCFFri7uU/4Blq8EIWn6HAMuFzADQ/a9A3RuxjmJ2jwpZfyA40SGJjG 2/dPh5B1AlWCdCVY36No9MCJ+tJCrGCudLG9P6bQLREBAiVQ0rXYJVyaVQSy6lVWK tTgMpAjl5cJmY9BxVA== X-UI-Sender-Class: 814a7b36-bfc1-4dae-8640-3722d8ec6cd6 Received: from [192.168.2.135] ([79.215.32.226]) by smtp.web.de (mrweb006 [213.165.67.108]) with ESMTPSA (Nemesis) id 1Ml4B6-1sao3V3ljY-00lRPA; Mon, 15 Apr 2024 11:03:41 +0200 Message-ID: Subject: Re: From CROSSTAB: One Column data with Two results columns From: Andreas Wagner To: M Sarwar , "pgsql-admin@lists.postgresql.org" Date: Mon, 15 Apr 2024 11:03:41 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.0 MIME-Version: 1.0 X-Provags-ID: V03:K1:xHW2KPJduCcvMXz6hgDUo+wRBN2tgurTZcI90BalqAJgqfocM6D hSirs70rtzuySOozkbkLXiwMGwUo8qwDAaEwdz7qEsonp+U6ZohehraNCZ09LOGnq398JGJ sr3+X2+BvEJT/fXibqhJ+AGl6p8Ks1QmHUsr1NvuxrRez80HT5m/mJigxV3X+hDOeoeYRCf uJf7Yc2zSZuw9URNV1cxA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:/rHDIxDag14=;yXySY9Dc9VSH1Fk79ossb2m2wsQ SSK7m/HMu5eyR/dKJUHlzvW/ZPc1nX2R/M7hGWsRtJ5wlJSgBVOlYKdwj1sqladlKCjE1/q6y cY2PUYzHZaPhx/mIz8D88bTXb/pzRuzq4ugqLf56ozpCm5AMZZvhV6OQdrAwYTjCyTqzAYYZL 0nctvePdgjpZzju6i2Fh2H17YQohJObixfHl5oW+4MKcSsdsVelIhI3XUxmxYSWNlYTOpe7Bx C2KdbAYwUBX0+NrgeleDPOE8l9hJHQwbZ2iutfLunk8Skt26Q6Gu4nuGIE/bzZx0CAXF1NRJX IlzTPw4LD2+nhzUDGyvbJOf9WW5j/fn+p1dFvwePyKVoIgUR6QvjZFYldEUPkHBQ91KMdTH8X dt7JVbYqouyWY1sXsWo4LsKstBQl2sM7cmwiMJOUUdzSEiDrK2xjt+OkzWhzUfsd7rotvCGJm pQ8yVjSfiel58Xfh+bgEt9So/lr4uMh1IEnvyLIQZQQVqhIG2O7lXZdb2hQ0abyOI2GdgDvHk VJL2Zcxcl10s/pEZdeXlynsipv/GOrt3wllSeRAi0wh2UzxMEbiowDbJyrLzfj7be2NLpO3kx TITiAdNQ7vsZXLr/VCEwuDtifg6roC92qFg1hFscJVkDusjG/zBYkSEoOdo1vjPkC6VXj6kyF vDXBZzDRQauC/NswSNMbPju5SQFBMJlOkl8CXNxrwJuoj+cJ8mh/MxwrxdRQBvV6ydnnkkyFx oIuYE9G1FF5mii0QrJjrRzyUWecYXwhtPO6MZnE+UO5m7oMrlFODi4wVLtfRqvdNhWFe+s4vw qJ+iJRJci+Ax6YhZZ1DPFluuDG9kQ3T+oSx3O3CZQ29I0= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello! Am Sonntag, dem 14.04.2024 um 20:54 +0000 schrieb M Sarwar: > Hi, > I am working CROSSTAB functionality to generate the reports in the > CSV format. > =C2=A0 > Now I have stage where I need to generate 2 result sets =C2=A0for the sam= e > 1 column data. Something like "CREATE VIEW"? The documentation has some useful examples: https://www.postgresql.org/docs/current/sql-createview.html "CREATE PROCEDURE" and "CREATE FUNCTION" are rarely covered by tutorials, so I mention them. They can be used in a similar manner. For CSV, I'm the wrong person. I'd code it in C/C++. Regards, Andreas Wagner