Re: MULTISET and additional functions for ARRAY - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: MULTISET and additional functions for ARRAY
Date
Msg-id AANLkTima6hAsuW=SmNNrz=nLWq9sRGW=5WN7k5YoY2Mm@mail.gmail.com
Whole thread Raw
In response to Re: MULTISET and additional functions for ARRAY  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
List pgsql-hackers
2010/11/15 Itagaki Takahiro <itagaki.takahiro@gmail.com>:
> On Mon, Nov 15, 2010 at 14:37, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> Maybe can be useful to implement a searching on sorted array.
>> You can hold a flag if multiset is sorted or not.
>
> Are you suggesting to add an IS_SORTED bit to for each ArrayType value?
> It might be possible, but I'm not sure how much it is useful.

It's depend on implementation. You can use this flag for large set and
operation MEMBER OF. When you know, so array is sorted, then you can
use a fast search.

>
> Another issue for sorting is that we have 4 kinds of sorting: ASC/DESC
> and NULLS FIRST/LAST. I always used the default sort order (ASC NULLS LAST)
> in the patch, but we might need to support all of them when we export the
> functionality. Then, we would need 2 bits for IS_SORTED flags.
>

yes, probably

Pavel

> --
> Itagaki Takahiro
>


pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Fix for seg picksplit function
Next
From: Andres Freund
Date:
Subject: Re: MULTISET and additional functions for ARRAY