Hi there, I'm trying to translate followings sql query to jooq (Postgres 9.2):
UPDATE mytableSET my_varchar_array = array_append(my_varchar_array, 'someNewText')WHERE my_id=6372 This is what i've got so far: createFactory() .update(MYTABLE) .set(MYTABLE.MY_VARCHAR_ARRAY, )) .where(MYTABLE.MY_ID.equal(6372)) .execute(); As you can see i don't have a clue what to write within ".set" except the tablename :( for those who don't know array_append, it adds a single element in an existing array. Hope someone can help?? greetings Andy -- 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/groups/opt_out.
