Skip site navigation (1) Skip section navigation (2)

subselect in the column list

From: amit sehas <cun23(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: subselect in the column list
Date: 2012-03-12 23:33:16
Message-ID: 1331595196.23527.YahooMailClassic@web160503.mail.bf1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
If we have a query of the form:

Select *, (Select * FROM T2 WHERE p2 = T1.p1) FROM T1 ORDER
BY 1 WHERE p3 = 75

In SQL, if a subselect is present in the column-list, is the
result set of this subselect considered to be a part of a
single tuple returned from the outer query, or does the result
set of the whole query look like a cross product of results
of outer and inner query 

thanks
-Amit

PS: sorry i tried to send this email earlier and accidentally pressed send before completing the email ...


Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2012-03-12 23:49:35
Subject: Re: pg_upgrade --logfile option documentation
Previous:From: Magnus HaganderDate: 2012-03-12 21:25:13
Subject: Re: GitHub mirror is not updating

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group