Re: [GENERAL] Populate arrays from multiple rows

2010-04-29 Thread Robert_Clift
w_foo GROUP BY 1,2; Cheers, Rob -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Wednesday, April 28, 2010 4:33 PM To: Clift, Robert Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Populate arrays from multiple rows On Wed, Apr 28, 2010 at 1:39 PM, wrote: &

Re: [GENERAL] Populate arrays from multiple rows

2010-04-28 Thread Merlin Moncure
On Wed, Apr 28, 2010 at 1:39 PM, wrote: > Good afternoon: > > I would like to insert some (1 or more) values from multiple rows of one > table into an array in another table. Here's the scenario: > > --table to house data provided by a third party > CREATE TABLE raw_foo ( >     rf_id serial P

[GENERAL] Populate arrays from multiple rows

2010-04-28 Thread Robert_Clift
Good afternoon: I would like to insert some (1 or more) values from multiple rows of one table into an array in another table. Here's the scenario: --table to house data provided by a third party CREATE TABLE raw_foo ( rf_id serial PRIMARY KEY, cde character varying(4), nb