Hi, i have a file-table in my DB with an "ID" as primary key and a second entry "file_ids" which is an integer array and a third entry "w_id"
for example: ID file_ids w_id 1 [3,6,7] 100 2 [1,7,2] 100 now i want update alle file_id arrays where the w_id is 100 and i want delete a number for example 7 in alle arrays. what is the fastest way to do this with jooq? can i search for number 7 and delete it directly with jooq ? after this operation the table should look like this: ID file_ids w_id 1 [3,6] 100 2 [1,2] 100 Best regards -- 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.
