How can I search a multidimensional array for an EXACT "subarray" match?
The following produces true when I want it to produce false. Obviously,
I would only want it to produce true for ARRAY[1,2], ARRAY[3,4], or
ARRAY[5,6].
SELECT ARRAY[ARRAY[1,2], ARRAY[3,4], ARRAY[5,6]] @> ARRAY[ARRAY[1,6]];
Any help is greatly appreciated.
Thanks.
Arthur