Arrays, multidimensional ANY (v 8.2)

From: Niklas Bergius <niklas(at)panagora(dot)se>
To: pgsql-sql(at)postgresql(dot)org
Subject: Arrays, multidimensional ANY (v 8.2)
Date: 2007-01-30 10:40:39
Message-ID: 45BF20A7.6050206@panagora.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-01-30 13:13:34 Re: Differentiate Between Zero-Length String and NULL Column Values
Previous Message Michael Fuhr 2007-01-30 05:45:43 Re: Differentiate Between Zero-Length String and NULL Column Values