Hey sorry if my answer is stupid, but there is an extension for array, even if it is limited to int (but int could be indexes of row) It's named http://www.postgresql.org/docs/9.3/static/intarray.html It provides essential function, although lacking some (I re-implemented union of array with disjoint result). I think this extension uses indexes
Cheers, Rémi-C 2013/10/10 Kaare Rasmussen <ka...@jasonic.dk> > Hi Merlin > > On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen <ka...@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<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<http://www.postgresql.org/mailpref/pgsql-general> >
