I want all row matching with group_id pass as input
ex.
Here is my table:-
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}');