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