Hi Merlin On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen <kaare@jasonic.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen <kaare@jasonic.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
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.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
