Is the intersect any better than what I originally showed? On the ROW approach, I'm not sure where the context for that is coming from since it may not be in the intersection. Consider n1 and n2 are NOT friends but they have >0 mutual friends between them.
On Thu, Dec 18, 2014 at 1:29 PM, David G Johnston <david.g.johnston@xxxxxxxxx> wrote:
Robert DiFalco wrote
> For 2 arbitrary ids, I need a query to get two pieced of data:
> * Are the two users friends?
This seems easy...ROW(u_id, f_id) = ROW(n1, n2)
> * How many friends do the two users have in common.
SELECT f_id FROM [...] WHERE u_id = n1
INTERSECT
SELECT f_id FROM [...] WHERE u_id = n2
Put those into WITH/CTE and use the main query to combine them in whatever
way seems appropriate.
David J.
--
View this message in context: http://postgresql.nabble.com/Combining-two-queries-tp5831378p5831391.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
