bind message supplies 2 parameters, but prepared statement \"\" requires 1

[DaliborTrampota]

Hi, I have this piece of code and for some reason it wont replace the $2 with the proper variable

code is varchar(10)
expiryDate is date

let imageID = 'ABCDEFG'
let lifetime = 604800000
await this.pg.query("INSERT INTO media(code, expiryDate) VALUES($1, CURRENT_DATE + INTERVAL '$2 ms')", [imageID, lifetime])

it says it requires only one parameter but I have two in there.

I have to make my query like this
await this.pg.query(INSERT INTO media(code, expiryDate) VALUES($1, CURRENT_DATE + INTERVAL '${lifetime} ms'), [imageID])

[boromisp]

You can't have a parameter inside an SQL string literal. You have to rewrite you query, a few examples:
https://stackoverflow.com/questions/68805215/how-to-pass-an-interval-parameter-to-a-prepared-statement

[charmander]

Duplicate of #2737

[DaliborTrampota]

makes no sense. I'll just use template literals... why it cant just replace $x with the variable??

[brianc]

... why it cant just replace $x with the variable??

this is a postgres behavior and has nothing to do with node-postgres. we don't parse/modify your query, we just send it to the backend. postgres itself has strict rules on what can be paramterized.