Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 30 Jan 2007 11:40:39 +0100
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
- Prev by Date: Re: Differentiate Between Zero-Length String and NULL Column Values
- Next by Date: Re: Differentiate Between Zero-Length String and NULL Column Values
- Previous by thread: Differentiate Between Zero-Length String and NULL Column Values
- Next by thread: Linked Databases
- Indexes: