Available in versions: Dev (3.22) | Latest (3.21) | 3.20 | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

User-defined data types (UDTs)

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

jOOQ has rich support for User-defined data types (UDTs) via CREATE TYPE statement as well via code generation. When generating code for a UDT as follows:

CREATE TYPE point (x double precision, y double precision)

... then, not only will there be a Point (org.jooq.UDT) and PointRecord (org.jooq.UDTRecord) generated, but also a DataType<PointRecord> is available for use in expressions of type PointRecord, wherever this UDT is referenced.

References to this page

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo