Is there any other way to search for a certain value in an
integer[]
SELECT * FROM table WHERE values *= 10;
'{11043,10859,10860,10710,10860,10877,10895,11251}'
'{11311,10698,10697,10710,10712,10711,10708}'
'10710'
For equality checks you can simply:
SELECT * FROM table WHERE 10 = ANY (values);
Read about ANY/SOME in the manual.