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]?
> 

Reply via email to