Subselect into collection?

Is it possible to perform a subselect returning the value in the outer query as a collection? Like - SELECT o, LIST{((SELECT x FROM y WHERE x.a = t.b))} As z FROM t- this fails with "A subquery has returned not exactly one row" [of course], but is there a syntax that would return a collection type as column z?

VERSION INFO??? Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jan 4, 2010 at 4:46 PM, Adam Tauno Williams <adam@morrison-ind.com>wrote: > Is it possible to perform a subselect returning the value in the outer > query as a collection? > > Like - > SELECT o, LIST{((SELECT x FROM y WHERE x.a = t.b))} As z > FROM t> - this fails with "A subquery has returned not exactly one row" [of > course], but is there a syntax that would return a collection type as > column z? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bd668bef8b4047c5eb8c0