Re: Array comparison & prefix search

From: Denes Daniel <panther-d(at)freemail(dot)hu>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Array comparison & prefix search
Date: 2009-12-05 15:36:18
Message-ID: cd515af0912050736n420c7bdescb7b23a917a900c4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/12/5 Merlin Moncure <mmoncure(at)gmail(dot)com>

> AFAIK, your approach is the only solution given your requirements. It
> works well...I've used it often, but usually for integers. Maybe
> there is a missing operator for arrays kinda similar to the contains
> operator that would be btree indexable.

Yes, I also think that an array prefix equality operator would be good to
have... but now that I've found it in the documentation that this solution
can be relied on (see my other mail), I can work around the lack of that.

Thanks,
Denes Daniel

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2009-12-05 15:39:13 Re: PostgreSQL Release Support Policy
Previous Message Denes Daniel 2009-12-05 15:31:52 Re: Array comparison & prefix search