A modern programming language that makes developers happier.

kotlinlang

In most cases the SQLDelight <https://cashapp.github.io/sqldelight/2.0.0/jvm_postgresql/query_arguments/#type-inference|runtime parameter type inference> works great, but in instances where it's ambiguous is it possible to specify the type in the query? I'm running into this for the first time and can't figure out the syntax.

Screenshot 2023-08-08 at 10.29.29 AM.png

Here's a query I had that worked. It relies on PostgreSQL to generate a `TIMESTAMP`.

Screenshot 2023-08-08 at 10.29.33 AM.png

And here's how I'm trying to change it now. I'd like to pass it `java.time.Instant` to use as a `TIMESTAMP`.

Screenshot 2023-08-08 at 10.29.22 AM.png

It's way off on the type of the parameter, inferring it should be a `org.postgresql.util.PGInterval`. Maybe SQLDelight doesn't understand the context of the parameter well enough.

Screenshot 2023-08-08 at 10.32.38 AM.png

This was my best guess, based on the syntax used for custom column types but it doesn't seem to work that way.

<@U01JRLZH77T> that works great for something like:
```AND sessionRecord.created_at = CAST(:now AS TIMESTAMP)```
(in fact the CAST isn't necessary here)

but in this case:
```AND sessionRecord.created_at &gt; CAST(:now AS TIMESTAMP) - INTERVAL '28 days'```
the resulting `now` parameter is still coming up as a `org.postgresql.util.PGInterval`.

Hm, this is definitely a bug. Explicitly casting the bind parameter should overwrite the implicit type. 

Ahh! Thanks for helping me figure out it's a bug so I can stop trying to fix my syntax. I'll file an issue.

Thanks. But I mean, there is no special handling yet, but should be. What's the point to specify the type explicitly if it is ignored/overwritten by the compiler?

My goal isn't to specify the type, rather to build a query that takes a `java.time.Instant` and uses it as a `TIMESTAMP` within the above query. Specifying the type was just the latest thing I was trying along the way.

I suppose I had assumed that would be the solution but I'm open to changing any syntax or approach you might suggest!

Yeah, I think so too.
Could you paste your query here (or in an issue)? Then I will take a look. I guess the subtraction operation changes the type somehow.

You got it, and thanks. Almost done submitting the issue.

<@U01JRLZH77T> <https://github.com/cashapp/sqldelight/issues/4504>

<@U01JRLZH77T> were you able to take a look?

Yes, but I need to find a proper solution but I am on vacation now. 

Awesome, thanks for taking a look and enjoy your vacation! :desert_island: