Re: Array comparison & prefix search - Mailing list pgsql-general

From Denes Daniel
Subject Re: Array comparison & prefix search
Date
Msg-id cd515af0912050736n420c7bdescb7b23a917a900c4@mail.gmail.com
Whole thread Raw
In response to Re: Array comparison & prefix search  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
2009/12/5 Merlin Moncure <mmoncure@gmail.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

pgsql-general by date:

Previous
From: Denes Daniel
Date:
Subject: Re: Array comparison & prefix search
Next
From: Perry Smith
Date:
Subject: tsvector from external files