I have an array of arrays [ID, TYPE].
All values are integer. Array can be integer[]
or jsonb
type.
SELECT array[[442,2],[443,2]]
SELECT to_jsonb(array[[1,2],[3,4]])
How can I check this array(s) contains array [443,2]?
EDIT One of the way to check described here.
1# SELECT array[[442,2],[443,2]] @> array[443,2] -- returns True
2# SELECT array[[442,2],[443,2]] @> array[2,443] -- returns True too
For my case, I want get False in 2#