Custom jOOQ binding for PostgreSQL int8multirange type.
PostgreSQL 14 introduces built-in multirange types. Support for these types is not yet available in jOOQ. This repository demonstrates a custom binding and converter to allow jOOQ to work with these types.
Create a field and set the DataType
with the binding.
private val rangesField = field(
name("test", "ranges"),
SQLDataType.VARCHAR.asConvertedDataType(Int8MultiRangeBinding())
)
See Int8MultiRange and associated tests for working examples.