jOOQ and selecting an enum field into enum object
<p>I'm using jOOQ with Postgresql to select an enum value from a table.</p>

<pre><code>List&lt;my.project.jooq.enums.Color&gt; colors =
dsl.selectDistinct(TABLE.T_COLOR.as("color"))
   .from(TABLE).fetch()
   .into(my.project.jooq.enums.Color.class);
</code></pre>

<p>Anyway I get the exception:</p>

<pre><code>org.jooq.exception.MappingException: No matching constructor found on type class my.project.jooq.enums.Color for record org.jooq.impl.DefaultRecordMapper@7c66447f
</code></pre>

<p>I see that <code>fetch()</code> will return <code>Result&lt;Record1&lt;my.project.model.jooq.enums.Color&gt;&gt;</code>, so I wonder if there is a way to immediately fetch the Color enums into a list as I can do with any pojo.</p>

<p>How can I fetch into the enum values?</p>