databases icon indicating copy to clipboard operation
databases copied to clipboard

Array SQL query fails to return the expected response.

Open abhishek-soam-78 opened this issue 4 years ago • 0 comments

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

abhishek-soam-78 avatar Feb 26 '21 07:02 abhishek-soam-78