Search Postgresql Archives

Re: Tree structure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <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 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux