Kevin, the missing precision on the timestamp precision in generated code
might be due to https://github.com/jOOQ/jOOQ/issues/11191, but wouldn't
affect the query in the way you're seeing.

You could indeed attempt to explicitly cast your arguments (e.g.
inline("").cast(VARCHAR)), but I don't see why you should have to. When
you're inlining the arguments, then PostgreSQL should be able to infer the
types (I can't reproduce your problem on my machine, with PostgreSQL 13 -
what version are you using of PostgreSQL and of the jdbc driver?).

I wonder if the jOOQ code you've shown is really the code you've executed.
Your stack trace shows fetchInto(), but you're showing a call to fetchOne()
- might not be relevant.

Can you help reproduce this? We have a template to create MCVE's (minimal,
complete, verifiable examples) here: https://github.com/jOOQ/jOOQ-mcve but
any other way would be useful too. I'd be looking out for anything specific
to your setup, including your Settings, JDBC connection parameters,
software versions, etc.

Thanks,
Lukas

On Tue, May 4, 2021 at 4:51 AM Rob Sargent <robjsarg...@gmail.com> wrote:

> Far as I can tell you only show three of the columns for the function def
> (schema, name, return type).
>
>
> khoj.get_transaction_record(unknown, unknown, unknown, unknown) does not
> exist
>
> But the parser doesn’t know the data type of each arg you’re passing in.
> Have you tried wrapping those in “cast”, especially the date.
>
> This seems a very cumbersome way of useing jOOQ.  Have you not generated
> classes, including for the functions?
>
>
>
>
> On May 3, 2021, at 8:32 PM, embree...@gmail.com <embree.ke...@gmail.com>
> wrote:
>
> khoj   | get_transaction_record | TABLE(uuid uuid, date_of_creation
> timestamp without time zone, date_of_expiration timestamp without time
> zone, user_name character varying, break_point bigint)|
>
>
> --
> 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 jooq-user+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/9F223085-88D8-45CA-871B-6112FD127C2B%40gmail.com
> <https://groups.google.com/d/msgid/jooq-user/9F223085-88D8-45CA-871B-6112FD127C2B%40gmail.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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 jooq-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/CAB4ELO7C0F%3Dx3DfLd%2BLaGC6peg-NCnNc-EiGPWerZC_Ysk_PJQ%40mail.gmail.com.

Reply via email to