Hi Lukas, Sorry for the late reply. This was an error on my part.
Thanks, Lou > On Apr 8, 2015, at 9:08 PM, Lukas Eder <[email protected]> wrote: > > 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] > <mailto:[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] > <mailto:[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] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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.
