Hi there, I'd love to help - but so far, I wasn't able to reproduce this issue. Would you mind posting an example query that helps us reproduce this issue?
Cheers, Lukas 2015-03-25 22:18 GMT+01:00 Lukas Eder <[email protected]>: > Hi, > > Thank you for reporting this. Interesting indeed - there are a couple of > cases where bind variables have to be cast in PostgreSQL, but this doesn't > look like a reasonable case. Could you please provide the Java/jOOQ code > that produced this issue? > > Thanks > Lukas > > 2015-03-19 10:03 GMT+01:00 <[email protected]>: > >> 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. >> > > -- 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.
