I want all row matching with group_id pass as input
ex.
Here is my table:-
x
id | name | group_id
----+----------------+----------
1 | Alice John | {1,2,3}
2 | joshn shukla | {1,4}
3 | rishikesh jain | {2,8}
when I execute below query:-
select * from employee where group_id::TEXT ~ '[{,]2,8[,}]'
then it returns result become
id | name | group_id
----+----------------+----------
3 | rishikesh jain | {2,8}
expected result all match:-
id | name | group_id
----+----------------+----------
1 | Alice John | {1,2,3}
3 | rishikesh jain | {2,8}
because 2 present in both rows. any solution ?
Advertisement
Answer
Try:
select * from employee where (group_id && '{2,8}');