Postgres Pro
Downloads
Home   >   mailing lists

Re: array_agg-like thing over arrays - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: array_agg-like thing over arrays
Date
Msg-id 20110114232132.GA65140@shinkuro.com
Whole thread Raw
In response to Re: array_agg-like thing over arrays  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
Tree view 
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@crankycanuck.ca

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_db_role_setting info not dumped
Next
From: Jasen Betts
Date:
Subject: Re: migrate hashname function from 8.1.x to 8.4