Hi Merlin
On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen <kaare@xxxxxxxxxx> 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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
