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 provides essential function, although lacking some (I re-implemented union of array with disjoint result).
I think this extension uses indexes
I think this extension uses indexes
Cheers,
Rémi-C
2013/10/10 Kaare Rasmussen <kaare@xxxxxxxxxx>
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 ancan you elaborate on that?
array. Using @> treats it as a set, AFAICT.
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
