search

falcony-io / sqlalchemy-searchable

Fulltext searchable models for SQLAlchemy. Only supports PostgreSQL
Other
263 stars 44 forks source link

Syntax error on older postgresql version #70

Closed riccardocagnasso closed 1 year ago

riccardocagnasso commented 6 years ago

I've a problem running the expression.sql content on a older postgresql version (9.4.5), i get a syntax error message.

LINE 208: ...s($1, $2))[(cardinality(array_positions($1, $2)) + $3 + 1):]

That is 

            WHEN $3 < 0 THEN
                (array_positions($1, $2))[
                    (cardinality(array_positions($1, $2)) + $3 + 1):
                ]

This works fine afaik on postgres 10. How can i patch this?

bjmc commented 6 years ago

I'm getting the same error here with Postgres 9.4.11.

jpvanhal commented 1 year ago

Closing as the minimum supported PostgreSQL version 11.