Re: Tree structure

Поиск
Список
Период
Сортировка
От Rémi Cura
Тема Re: Tree structure
Дата
Msg-id CAJvUf_uqRXE-Osc5Yp7F7GZK8NsVV6qaGJiSF0A_97Omk3SzAQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tree structure  (Kaare Rasmussen <kaare@jasonic.dk>)
Ответы Re: Tree structure  (Kaare Rasmussen <kaare@jasonic.dk>)
Список pgsql-general
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

Cheers,
Rémi-C


2013/10/10 Kaare Rasmussen <kaare@jasonic.dk>
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Why doesn't update syntax match insert syntax?
Следующее
От: Kaare Rasmussen
Дата:
Сообщение: Re: Tree structure