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: [email protected]
WWW: http://www.sigaev.ru/
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
