Search Postgresql Archives

Re: Select rows when all all ids of its children records matches

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



IN is OR, I want the AND logic. Select posts which has tag 1, 2 and 3 ( tag ids )


Thanks,

Arup Rakshit



On 12-Sep-2018, at 8:58 PM, Ron <ronljohnsonjr@xxxxxxxxx> 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




--
Angular momentum makes the world go 'round.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux