Re: [GENERAL] Prefix search on all hstore values

2013-11-28 Thread Albert Chern
Thanks for the suggestions! My requirements can be relaxed to full text search, but the problem I had with that approach is I have strings in Chinese, and postgres doesn't seem to support it. Calling to_tsvector() on Chinese characters always returns an empty vector. A separate table will defini

[GENERAL] Prefix search on all hstore values

2013-11-27 Thread Albert Chern
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