On Fri, 2007-10-05 at 10:32 -0700, Stephan Szabo wrote: > On Fri, 5 Oct 2007, Simon Riggs wrote: > > > Because we already do exactly that here: > > > > select 1, (select col2 from c), 3; > > > > The inner select returns a ROW, yet we treat it as a single column > > value. > > The inner select does not return a row. It's not a <row subquery>, it's a > <scalar subquery>.
Thanks Stephan, Tom already explained that. My comments above were in response to "Why would you think that?" -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
