Re: Combining two queries

Поиск
Список
Период
Сортировка
От Robert DiFalco
Тема Re: Combining two queries
Дата
Msg-id CAAXGW-zsAyN9PEtoEojXgvqUWS+WWsGcaWmO0oDVv07KW2dffw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Combining two queries  (David G Johnston <david.g.johnston@gmail.com>)
Ответы Re: Combining two queries  (David Johnston <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
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@gmail.com> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: John McKown
Дата:
Сообщение: Re: Combining two queries
Следующее
От: David Johnston
Дата:
Сообщение: Re: Combining two queries