Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXqnf-0008A9-2w for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 21:49:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXqnd-0007XX-U5 for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 21:49:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXqnd-0007XO-JB for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 21:49:17 +0000 Received: from mail-qt1-x82e.google.com ([2607:f8b0:4864:20::82e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pXqnb-0002sS-Ml for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 21:49:17 +0000 Received: by mail-qt1-x82e.google.com with SMTP id c18so887497qte.5 for ; Thu, 02 Mar 2023 13:49:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1677793754; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=hBHUG/eDrJkETkcgTPqIGmQUWp7MChq1LG/l48IP/Iw=; b=h6VCMJwjWPp/o9SO5Fn8T2jzNC5Zf401SmESUWVMQF2V1hC2LryIiMIkOi8rvX/vdm NCt0JJWbeI+dPDvG7aTjgmDhI9QsGFDnM6wHxuZ3jgnza+3+xn1d/i1aZebHXxpzdx6O L6RJhjX/jBRceY32nMUM3DzvEfCfNMcuuEwMpx2UzgSXpy8S0BzPpdJaSYqMbx0JNd3k vgwLOdc2G+Of+7cDU94DEfWgNwfPNgz4g729/b15HMZqtgJ1J/IKqqA8Xt2EUPtuYTMb N1P1Uwu6XIW2BUeqCaCTNKlX/x6kfjmUH8je1Qid0xYCpVlhOtt5kL+roym+vw1C3HNj PH1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1677793754; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=hBHUG/eDrJkETkcgTPqIGmQUWp7MChq1LG/l48IP/Iw=; b=6ik02C6JGWrE19MR/9ossMnrIWtn1xnrEXQSTiW9BYKYmnHUW3Lch/ckRtK2u1hUCY 437L85ebaGjtjIZD0HoYddVE3XC8Sb5L6wpQOD4U98xP1iyLtqsqQBwNyS21xW92c9KP 217IxtIfZcF9+TYoxKncy1lWYHFFlZvPwYwPnwFsLVxJSrlwXHDMIOHSw6vwY58DLP6i EjHBdf5Wcz9MUqnYe3P9R2b6X8bpoYORNy3E9a+faZbasM4pDXFvzVST67fYdBpKh2rc 8220N7RdYWeS2MMr6H8TK87+LTsdJH4iL0rsvUghgdPHromoGKwqTozDJoRpEq5yLwWq im3A== X-Gm-Message-State: AO0yUKUSgHe3zCU8RDF0sO2vHJSGbD+kX2dnOMIafFn5Dl5ed90iGuf9 yai5AGY7Shpx1byurqZ1pMUy/OLORNQ= X-Google-Smtp-Source: AK7set8zJBOrFD5qhEzA+v+NcY178VOmyGobxfa68uDszGFm3rzm78Ojg3/aVCTyVrHFMZ5QN6PiOw== X-Received: by 2002:ac8:5c47:0:b0:3b8:68df:fc75 with SMTP id j7-20020ac85c47000000b003b868dffc75mr19115387qtj.31.1677793754059; Thu, 02 Mar 2023 13:49:14 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id b1-20020ac84f01000000b003bb8c60cdf1sm457126qte.78.2023.03.02.13.49.13 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Mar 2023 13:49:13 -0800 (PST) Message-ID: <36f53642-db43-4fc9-028e-8b6cd3dff9b4@gmail.com> Date: Thu, 2 Mar 2023 15:49:13 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Converting row elements into a arrays? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <788ab733-d0d1-7791-fb22-7c2724b08816@gmail.com> From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/2/23 15:45, Rob Sargent wrote: > On 3/2/23 13:58, Ron wrote: >> Postgresql 12.13 >> >> Given the sample below, I'm looking for how to generate this output.  >> It's like GROUP BY, but generating an array instead of an aggreate number. >>  f1 | f2_array >> ----+--------- >> 1 | {1,2,3} >>   2 | {1,2,3,4} >>   3 | {1,2} >> >> The ultimate goal is to somehow use pg_index.indkey to get column names >> from pg_attribute. >> >> create table foo (f1 int, f2 int); >> insert into foo values (1, 1); >> insert into foo values (1, 2); >> [snip] > > In which environment are you accessing that array?  psql only? Correct. -- Born in Arizona, moved to Babylonia.