Re: Tree structure - Mailing list pgsql-general

From Kaare Rasmussen
Subject Re: Tree structure
Date
Msg-id 5256BE28.4090607@jasonic.dk
Whole thread Raw
In response to Re: Tree structure  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Tree structure  (Rémi Cura <remi.cura@gmail.com>)
List 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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Re: [GENERAL] Forms for entering data into postgresql
Next
From: Rob Richardson
Date:
Subject: Why doesn't update syntax match insert syntax?