Hi Lukas, What is the current idiomatic way to bind to a TIMESTAMP WITH TIME ZONE in Postgres?
I’ve seen the pointer to implement a Binding https://www.jooq.org/doc/3.10/manual/code-generation/custom-data-type-bindings/ So I was wondering if there is an example somewhere for TIMESTAMP WITH TIME ZONE? For reference, my schema has aliased TIMESTAMP WITH TIME ZONE in this way (to enforce UTC everywhere): CREATE DOMAIN UTC_TIMESTAMP AS TIMESTAMP WITH TIME ZONE CHECK (EXTRACT(TIMEZONE FROM VALUE) = 0); CREATE TYPE UTC_RANGE AS RANGE ( SUBTYPE = UTC_TIMESTAMP ); Cheers, Ben -- 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.
