Search Postgresql Archives

Re: Prefix search on all hstore values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx
                                                   WWW: http://www.sigaev.ru/


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux