Hi Merlin
> On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen <kaare(at)jasonic(dot)dk> wrote:
>> I'm quite surprised there seem to be no way in core to treat an array as an
>> array. Using @> treats it as a set, AFAICT.
> can you elaborate on that?
>
> merlin
To me, an array is a vector (or a vector of vectors). So I'm looking for
an operator where
ARRAY[1,4,3] doesn't contain ARRAY[3,1] and
ARRAY[2,7] isn't contained by ARRAY[1,7,4,2,6] (but ARRAY[1,7,4] is)
IOW order matters to me, but not to the array operators mentioned in
http://www.postgresql.org/docs/9.3/static/functions-array.html. Note
that index support is important.