If that is not an option, then you should probably create a function taking
the HSTORE key and the sought key and returning the corresponding value or
NULL.
On Mon, Mar 17, 2014 at 11:41 PM, Tiago Rodrigues <wtrm...@gmail.com> wrote:
> 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
>
--
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
