can't use interval

[antonio-antuan]

Greetings and thanks for your project.

Could you tell me how can I fix this error?

error: error returned from database: operator does not exist: timestamp with time zone - text
    |
164 |           Ok(sqlx::query_as!(
    |  ____________^
165 | |             models::Source,
166 | |             "SELECT * FROM sources WHERE last_scrape_time < NOW() - $1",
167 | |             Duration::from_secs(check_secs_interval)
168 | |         )

[abonander]

We usually leave it up to Postgres to infer the types of bind parameters and then tell us what it's expecting, but in cases like this, it fails to infer and falls back to the default type, TEXT.

You can hint at the type of the bind parameter in SQL by adding a cast, like so, and then this should compile:

SELECT * FROM sources WHERE last_scrape_time < NOW() - $1::interval

Converting this to a Q&A discussion since it doesn't really concern a bug in SQLx, it's just a limitation of our interface with Postgres and of proc macros (since we can't ask the compiler the type of the bind expression and tell Postgres what it is).