Re: Prefix search on all hstore values

Hi!

Full-text search has this feature.

# select to_tsvector('en_name=>yes, fr_name=>oui'::hstore::text) @@ 'en:*';
  ?column?
----------
  t


or (index only keys)

select to_tsvector(akeys('en_name=>yes, fr_name=>oui'::hstore)::text) @@ 'en:*';
  ?column?
----------
  t

To speed up this queries you use functional indexes.


Albert Chern wrote:
> Hi,
>
> I have an hstore column that stores a string in several arbitrary languages, so
> something like this:
>
> "en" => "string in english", "zh" => "string in chinese", "fr" => "string in french"
>
> Is it possible to construct an index that can be used to determine if a query
> string is a prefix of ANY of the values in the hstore?  From reading the
> documentation the closest I've gotten is a gin index after converting the values
> to an array, but that doesn't seem to work with prefix searching.  Any pointers
> would be much appreciated!
>
> Thanks,
> Albert

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/