Select rows when all all ids of its children records matches

[Arup Rakshit]

I have a table posts(id, name), posts_tags(post_id, tag_id) and tags (id, name) 
... I want to get all posts which has tag id 1, 2 and 3 for example. How should 
I do this? I tried ALL, but it didn’t work.

Those tag ids comes from UI by users, so I am looking for generic approach.


Thanks,

Arup Rakshit
a...@zeit.io