Re: array_agg-like thing over arrays

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: array_agg-like thing over arrays
Date: 2011-01-14 23:21:32
Message-ID: 20110114232132.GA65140@shinkuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jan 15, 2011 at 01:35:20AM +0300, Dmitriy Igrishin wrote:
> Try SELECT item_id, array_agg(arrayofstuff::text) from eg1 WHERE class_id =
> 1;

Doh! That's it. Thanks!

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2011-01-14 23:36:28 Re: migrate hashname function from 8.1.x to 8.4
Previous Message Tom Lane 2011-01-14 22:52:18 Re: pg_db_role_setting info not dumped