Does anybody know is it possible to update value by key in *hstore* using JOOQ, except executing plain sql. For example, I have table *products:*
*id | characs | name ----+----------------------------------------------------------------------------+-------------- 1 | "key"=>"value", "key3"=>"test2" | test1 2 | "key"=>"value" | test3 3 | "keyNew"=>"valueNew" | test3 4 | "keyNew"=>"valueNew" | test4 5 | "date"=>"Dec 2012", "price"=>"500", "author"=>"Dave", "currency"=>"dollar" | test5* *And I want to update value by key key3. For that I can execute plain sql:* *UPDATE products SET name='test1New', characs=characs || '"key3"=>"value3"'::hstore where id=1* *But I can't find the way how to do it using ** JOOQ's DSL.* *Is it possible?* -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
