Hi,

Im currently trying out the seek command in jooq using a postgresql 
database. Unfortunately, I don't understand why jooq is casting my 
timestamp seek input as a varchar, thereby failing to compare it with the 
field.

ERROR: operator does not exist: timestamp without time zone < character 
varying

Here is the snippet of the query where jooq casts the seek parameter:

(\"giftcards\".\"id\", \"giftcards\".\"sold_datetime\") < (?, cast(? as 
varchar))) order by \"giftcards\".\"id\" desc, 
\"giftcards\".\"sold_datetime\" desc limit ?];


Thanks,
Lou

-- 
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.

Reply via email to