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