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.
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 FROM posts_tags_cte JOIN
posts ON 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]?
|
