Re: Tree structure
| От | Kaare Rasmussen |
|---|---|
| Тема | Re: Tree structure |
| Дата | |
| Msg-id | 5256BE28.4090607@jasonic.dk обсуждение исходный текст |
| Ответ на | Re: Tree structure (Merlin Moncure <mmoncure@gmail.com>) |
| Ответы |
Re: Tree structure
|
| Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: