Jooq postgres array sql. This works the same way as the Oracle specific KEEP clause. I don't understand how to make it for Postgres array UPD What I've tried: doesn't Despite successfully saving the data, retrieving it leads to a ClassCastException: class org. For example, I want to look up rows with ID 5,100, 3, 500, 200 and return them in that specific order. Is there a way to have jOOQ generate a List<String> instead? I'm using Postgres and Jooq object JooqBuilder { private val defaultSettings = new Settings() . 2 and jOOQ 3. I am using jOOQ (with PostgreSQL). Regrettably, it never really took off. But your domain model might be more specific, or you might be using a vendor-specific data type, such as JSON, HSTORE, or Call postgres function with array param in jooq 5 How to make JOOQ to use arrays in the IN clause 1 Can't write Postgres array-column using jOOQ 4 jOOQ - array of select query 1 Using Jooq to set a Character Array instead of 3 By default, for a Postgresql ARRAY column like varchar[], jOOQ generates a corresponding array field, String[] in this case. I stumbled upon a very interesting question on Stack Overflow about how to use jOOQ’s MULTISET operator to nest a collection, and then filter the result by whether that nested collection contains a value. lyqkzprlyttqxdpcxaguzoymutifczngafsshytvhfsyezyhrbjbbbzodhfmlwmwbiivokugfonatervvedq