Strange translation of jOOQ query for array contains function
<p>I have the following type in my PostgreSQL database :</p>

<pre><code>myoptions text[]
</code></pre>

<p>I use a jOOQ converter so that I have a Set as corresponding type in my record :</p>

<pre><code>Set&lt;String&gt; myoptions
</code></pre>

<p>In my query I have the following Condition :</p>

<pre><code>c.MYOPTIONS.contains(Sets.newHashSet("option1"))
</code></pre>

<p>which is translated in SQL like this :</p>

<pre><code>cast("c"."myoptions" as varchar) like ('%' || '[option1]' || '%') escape '!'
</code></pre>

<p>Is it the normal behavior ?</p>

<p>I would like to have something like :</p>

<pre><code>c.myoptions @&gt; ARRAY['option1']
</code></pre>

<p>or</p>

<pre><code>'option1' = ANY(c.myoptions)
</code></pre>

<p>Thanks in advance for your help</p>