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 1pXqw5-0000G8-03 for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 21:58:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXqw3-0004Wv-QQ for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 21:57:59 +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 1pXqw3-0004VK-DH for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 21:57:59 +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 1pXqw1-0002xn-GP for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 21:57:59 +0000 Received: by mail-qt1-x82e.google.com with SMTP id h19so897904qtk.7 for ; Thu, 02 Mar 2023 13:57:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1677794276; 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=yp4weC8S5TslHTH7tk/kAfUI93aeZ3Ee7qMCV6lueZY=; b=I96Kuyk8Elsmkg3DcNj4hdcv+SF8OWjJR3I9C94FREtjsfmndIotYkyn5ncpqyIqBZ hcRxA71kAcjibkuGVKkiCBlG+IJn7JjIvwlEnYD720IVdcR4qodXnR+NETAYkIARPdME O3zgIQHHnReXnrhBw6wI3XonINKW6IXe4ODTTp6RkJZ+83Hvnvi99vVHBHTM6m9bUIYb qQglHRVCqCVJbryoNvZOmV8zqXaoXpv8aIGiejKmCiQx9dP4+Jcg/1mpNawwLgQRpEf3 7HyXNdd6XjjIxLu1vxDICP8I0lnzGvxaQBw9iI/5oX5wpE9SNU3lyMk4GDhLWEFvGEFe 1/WQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1677794276; 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=yp4weC8S5TslHTH7tk/kAfUI93aeZ3Ee7qMCV6lueZY=; b=l3udS3qHbSVtdgmA+Fiod5FKP5GW4dbw3ncd8IzhOwju7rlbJWkksMoec4N1FNkGi5 UFYSIA+K6VIs38dayxVQxRQY3KXpWM5ngfLr6J4b17DMDfvHJKQffvUQs1lTYpi3Z0Bj vTXCqp0Nd/uxX30YYs09feZ85H4JGz/1jDKw0Lvj+AacfaYPktMJZzqfkrlzR8narqFf ViYdspRZeGN4C3A4/AaJ7meWnrO+4dDWHOHJHjU530XWIQyRU7PSJSAZHiOLx8y9Iplv Ul/VtvMG4NBm72zfwKGp84fhx/NRmKyMuQWt1jzZOCYZUC0pk5XwMaXMb9BEYTpqWjuE yYmA== X-Gm-Message-State: AO0yUKXt277AGFSHVxxL+3m6nimlBzPIVFwYWagjqw/6VpZ4c40hxjV0 /owk6CaSGkFhDkmEQ261drN/v+KMCGQ= X-Google-Smtp-Source: AK7set+Smqv79erycj1gYKj9kln6yKueom7sZXpWCrrNbbBz2C5qKdnnO3Kq8NNty/N3G4GS0kOX5w== X-Received: by 2002:ac8:7e87:0:b0:3ba:1696:87cf with SMTP id w7-20020ac87e87000000b003ba169687cfmr20124727qtj.44.1677794275936; Thu, 02 Mar 2023 13:57:55 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id y8-20020ac81288000000b003a530a32f67sm457724qti.65.2023.03.02.13.57.55 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Mar 2023 13:57:55 -0800 (PST) Message-ID: <8f6144d5-25f7-bfe4-bc63-df318c08dc47@gmail.com> Date: Thu, 2 Mar 2023 15:57:55 -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: Ray O'Donnell , pgsql-general@lists.postgresql.org References: <788ab733-d0d1-7791-fb22-7c2724b08816@gmail.com> <18b226e4-d018-c3b1-9dae-378bf67af346@rodonnell.ie> From: Ron In-Reply-To: <18b226e4-d018-c3b1-9dae-378bf67af346@rodonnell.ie> 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:01, Ray O'Donnell wrote: > On 02/03/2023 20: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} > > Something like this (off the top of my head)? - > >    select f1, array_agg(f2) as f2_array group by f1; > > Hope that helps (and that it's right!). That did it. -- Born in Arizona, moved to Babylonia.