Aren't you looking for cte.tags = array[1,2]?
On 12-Sep-2018, at 9:47 PM, Rob Sargent <robjsargent@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 FROM posts_tags_cte JOIN posts ON posts.id = posts_tags_cte.post_idWHERE 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]?
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_idWHERE posts_tags_cte.tags @> array[1, 2]::int8[]But it gives me all the posts.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных