makeitnew's Profile

Is it possible to search an hstore by value instead of by key? For example, find all records for which value is 'red', regardless of key? The documentation doesn't say and this is likely a deliberate omission.

As an alternative, has anyone tried to build a key-value store using an association? That is, "product hasmany key_values", where key_values is a table with two indexed attributes, key and value.