From: Andreas Joseph Krogh <andreak@officenet.no>
Organization: OfficeNet AS
To: pgsql-sql@postgresql.org
Subject: OT: array_accum equivalent in Oracle
Date: Fri, 12 Oct 2007 16:16:27 +0200
User-Agent: KMail/1.9.6
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200710121616.28023.andreak@officenet.no>

WARNING: The rest of this post is for somebody who has worked with Oracle a=
nd=20
has migrated to PG, or for some other reason has good experience with Oracl=
e.

I know this is off-topic for this list and should be asked in an Oracle=20
support-forum, but I don't have access to that, and Uncle Google didn't=20
return any obvious results, so here it goes...

Anybody knows if Oracle has an equivalent of PG's array_accum or=20
ARRAY(subselect) construct?

I need a way to accomplish this in Oracle:
select ARRAY(select t.id from table t where t.user_id =3D u.id) as=20
id_array, ....

Any hints on where to look in Oracle-docs are welcome.

=2D-=20
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / Manager
=2D-----------------------+---------------------------------------------+
OfficeNet AS            | The most difficult thing in the world is to |
Karenslyst All=C3=A9 11      | know how to do a thing and to watch         |
PO. Box 529 Sk=C3=B8yen      | somebody else doing it wrong, without       |
0214 Oslo               | comment.                                    |
NORWAY                  |                                             |
Tlf:    +47 24 15 38 90 |                                             |
=46ax:    +47 24 15 38 91 |                                             |
Mobile: +47 909  56 963 |                                             |
=2D-----------------------+---------------------------------------------+