I'm sure this has been answered before, but the search seems to be down
How can I convert the results of a subselect into an array? IE:
CREATE TABLE a(a int, b int, c int);
INSERT INTO table_a
SELECT a, b, (SELECT c FROM table_c WHERE table_c.parent = table_b.id)
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
pgsql-docs by date
|Next:||From: Michael Fuhr||Date: 2004-10-28 23:21:52|
|Subject: Re: Turning a subselect into an array|
|Previous:||From: Ian Barwick||Date: 2004-10-28 20:34:27|
|Subject: FAQ and Windows|
pgsql-general by date
|Next:||From: Tom Lane||Date: 2004-10-28 22:39:39|
|Subject: Re: Derived tables? |
|Previous:||From: Joshua D. Drake||Date: 2004-10-28 21:55:41|
|Subject: Re: Sorting street addresses|