Re: Tree structure

From: Kaare Rasmussen <kaare(at)jasonic(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Tree structure
Date: 2013-10-10 14:48:08
Message-ID: 5256BE28.4090607@jasonic.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Merlin

> On Thu, Oct 10, 2013 at 1:00 AM, Kaare Rasmussen <kaare(at)jasonic(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-10-10 15:02:46 Re: Why doesn't update syntax match insert syntax?
Previous Message Merlin Moncure 2013-10-10 13:48:03 Re: Re: [GENERAL] Forms for entering data into postgresql