Arrays, multidimensional ANY (v 8.2) - Mailing list pgsql-sql

From Niklas Bergius
Subject Arrays, multidimensional ANY (v 8.2)
Date
Msg-id 45BF20A7.6050206@panagora.se
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Differentiate Between Zero-Length String and NULL Column Values
Next
From: Andrew Sullivan
Date:
Subject: Re: Differentiate Between Zero-Length String and NULL Column Values