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

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 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