Hello, Unfortunately, PostgreSQL's INTERVAL data types are currently not yet fully supported as standalone data types, only as arguments to date time arithmetic functions. This is part of the following feature request: https://github.com/jOOQ/jOOQ/issues/2230
As a workaround, you could easily implement your own data type binding as documented here: http://www.jooq.org/doc/latest/manual/sql-building/queryparts/custom-bindings Hope this helps, Lukas 2016-11-13 18:23 GMT+01:00 <[email protected]>: > I try to query by a given Interval: > > dsl.select(ABC.DEF).from(ABC).where(ABC.INTERVAL.eq(pgInterval)).fetch(); > > But I get the warning: Not supported by dialect : Type class > org.postgresql.util.PGInterval is not supported in dialect POSTGRES > > And the Exception: > > org.jooq.exception.SQLDialectNotSupportedException: Type class > org.postgresql.util.PGInterval is not supported in dialect POSTGRES > > What can I do? > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
