How to pass parameters to SQL query?
In a postgres SQL query like
SELECT * FROM <tablename> WHERE id in $1
where $1 is a list of ids I got constantly the error
{
"error": {
"name": "ExecutionErr",
"message": "error during execution of the script:
db error: ERROR: syntax error at or near "$1""
}
}
So I tried to enforce $1 to be a string with "$1:TEXT" with same result.
Any idea what I'm missing here ?
SELECT * FROM <tablename> WHERE id in $1
where $1 is a list of ids I got constantly the error
{
"error": {
"name": "ExecutionErr",
"message": "error during execution of the script:
db error: ERROR: syntax error at or near "$1""
}
}
So I tried to enforce $1 to be a string with "$1:TEXT" with same result.
Any idea what I'm missing here ?
