Thursday, April 28, 2016

PostgreSQL: check element contained in array

Contained:
select 1 = any (array[2, 4, 6]);
NOT contained:
select 1 != all (array[2, 4, 6]);