Find users that have ALL categories - Mailing list pgsql-general

From Nick
Subject Find users that have ALL categories
Date
Msg-id 4242fee6-0665-4d46-a30f-7853b0e1d89f@j17g2000prn.googlegroups.com
Whole thread Raw
Responses Re: Find users that have ALL categories  (David Fetter <david@fetter.org>)
List pgsql-general
Is this the most efficient way to write this query? Id like to get a
list of users that have the categories 1, 2, and 3?

SELECT user_id FROM user_categories WHERE category_id IN (1,2,3) GROUP
BY user_id HAVING COUNT(*) = 3

users_categories (user_id, category_id)
1 | 1
1 | 2
1 | 3
2 | 1
2 | 2
3 | 1
4 | 1
4 | 2
4 | 3

The result should produce 1 & 4.

pgsql-general by date:

Previous
From: Zoid
Date:
Subject: LINE 1: IDENTIFY_SYSTEM error infinitum
Next
From: MD
Date:
Subject: Looking for multithreaded build of libpq for Windows