Hi Rob, I figured it out. thanks. It is giving correct data.
> Aren't you looking for cte.tags = array[1,2]? posts_tags_cte has tags column, so I am using it. Thanks, Arup Rakshit a...@zeit.io > On 12-Sep-2018, at 9:47 PM, Rob Sargent <robjsarg...@gmail.com> wrote: > > > > On 09/12/2018 10:08 AM, Arup Rakshit wrote: >> I tried : >> >> WITH posts_tags_cte AS ( >> SELECT post_id, array_agg(tag_id) as tags >> FROM posts_tags >> WHERE tag_id in (1, 2) >> GROUP BY post_id >> ) >> SELECT posts.id <http://posts.id/> FROM posts_tags_cte JOIN posts ON >> posts.id <http://posts.id/> = posts_tags_cte.post_id >> WHERE posts_tags_cte.tags @> array[1, 2]::int8[] >> >> But it gives me all the posts. >> >> > Aren't you looking for cte.tags = array[1,2]? >
