I have a TYPE defined say customtype and have a table where one of the 
columns is customtype[]. 
I am trying to find ways where I can execute the below sql query in JOOQ:

update MY_TABLE SET customtypecolumn = array_remove(customtypecolumn, 
('test3','-1')::customtypecolumn) where <some_condition>

I tried following this 
link 
https://jooq-user.narkive.com/ScEfUAlX/fastest-way-to-remove-values-from-an-integer-array
But this way I am getting exception TYPE customtype is not supported in 
dialect POSTGRES

-- 
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].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/78e86317-41d1-41ed-ba6d-f2060ac3018an%40googlegroups.com.

Reply via email to