Hello everyone.Can anyone tell me how I can test for the occurrence of an array in an array? Intuitively, this should work:
SELECT ARRAY[1,2,3] = ANY(ARRAY[[1,2,3],[2,3,4]]);However, this gives me "operator does not exist: integer[] = integer". I'm running 8.2.
--
Niklas Bergius
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
