Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16

Computed columns

Applies to ❌ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

Computed columns, sometimes also called "virtual" columns, are columns that are generated from an expression based on other columns of the same row directly in the database. They cannot be written to, but may be used in projections, filters, and even indexes, as a complement or replacement of function based indexes.

jOOQ's code generator picks up computed columns like any other, but marks them as read only for your convenience, such that they are excluded from DML statements, by default.

See the section about computed columns in CREATE TABLE for more details.

References to this page


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

The jOOQ Logo