Array Contained By Array Question - Mailing list pgsql-novice

From Arthur M. Kang
Subject Array Contained By Array Question
Date
Msg-id 4DF23F97.2040109@gmail.com
Whole thread Raw
Responses Re: Array Contained By Array Question  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: "Charles N. Charotti"
Date:
Subject: Re: Indenting PLPGSQL code
Next
From: Merlin Moncure
Date:
Subject: Re: Array Contained By Array Question