Generally, I'd suggest you take these HSTORE key-value-pairs types and
recast them as a separate table (say, HSTORE (STORE integer primary key,
KEY text, VALUE text) ) and then query (SELECT VALUE FROM {TABLE1} JOIN
HSTORE ON HSTORE.STORE = {TABLE1}.{HSTORECOLUMN} WHERE VALUE = 'some_key';)On Mon, Mar 17, 2014 at 10:46 PM, Stefan Keller <sfkel...@gmail.com> wrote: > Hi, > > I have a column which contains a string structure taken from the > PostgreSQL HSTORE key-value-pairs type. This is an example of one > column value: > > "operator"=>"police","name"=>"Zurich","some_key"=>"some_value" > > Any suggestions on how to query this most efficiently (like [select > value from "some_key"])? > > Yours, Stefan > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- In those days, in those distant days, in those nights, in those remote nights, in those years, in those distant years... - Gilgamesh, Enkidu and the Underworld _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
