Extended data types

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

Some RDBMS support additional data types that are very specific to that RDBMS, such that jOOQ does not offer support for them from the core library. Additional extension modules can be used to import:

• Data type converters for simple cases
• Data type bindings to ensure optimal JDBC interaction
• Data type formatters to help embed extended types in certain built-in types, such as JSON (JSON) or XML (XML).

Table of contents

3.14.3.1.

PostgreSQL CIDR type

3.14.3.2.

PostgreSQL CITEXT type

3.14.3.3.

PostgreSQL DATERANGE type

3.14.3.4.

PostgreSQL HSTORE type

3.14.3.5.

PostgreSQL INET type

3.14.3.6.

PostgreSQL INT4RANGE type

3.14.3.7.

PostgreSQL INT8RANGE type

3.14.3.8.

PostgreSQL LTREE type

3.14.3.9.

PostgreSQL NUMRANGE type

3.14.3.10.

PostgreSQL TSRANGE type

3.14.3.11.

PostgreSQL TSTZRANGE type