From: | Arup Rakshit <ar(at)zeit(dot)io> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Select rows when all all ids of its children records matches |
Date: | 2018-09-12 15:30:46 |
Message-ID: | 5E56CBFF-62E6-4C17-B6D8-BBC05BC10C8B@zeit.io |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
IN is OR, I want the AND logic. Select posts which has tag 1, 2 and 3 ( tag ids )
Thanks,
Arup Rakshit
ar(at)zeit(dot)io
> On 12-Sep-2018, at 8:58 PM, Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> Maybe this:
> select p.id, p.name
> from posts p,
> posts_tags pt,
> tags t
> where t.id in (1, 2, 3)
> and t.id = pt.tag_id
> and pt.post_id = p.id;
>
>
> On 09/12/2018 10:23 AM, Arup Rakshit wrote:
>> 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
>> ar(at)zeit(dot)io <mailto:ar(at)zeit(dot)io>
>>
>>
>>
>
> --
> Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-09-12 15:43:03 | Re: Select rows when all all ids of its children records matches |
Previous Message | Ron | 2018-09-12 15:28:27 | Re: Select rows when all all ids of its children records matches |