Hi all,

I need a little push in the right direction. I'm trying to update a JSON
field in Postgres that means adding a new key/value pair to an existing
JSON column.

In SQL, I'd do something like UPDATE my_table SET my_column = my_column ||
'{"key": "value"}'
In jooq, I'd do ctx.update(MY_TABLE).set(MY_TABLE.MY_COLUMN, ??????)

So what is ????? :-) I expect I have to write some plain sql which is ok
for me but I don't really know how to do that at this point.

Thanks in advance!!

Julian

-- 
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.

Reply via email to