databases
databases copied to clipboard
Array SQL query fails to return the expected response.
I am trying to execute this piece of code and I am stuck on this.
tokens = ['a', 'hello']
response = await database.fetch_all(query="""select * from word where text ilike any (array :token)""", values={"token" :tokens})
It gives this on Postgres console ERROR: syntax error at or near "$1" at character 48
Any suggestions? Please help
Thanks