search

Jaymon / prom

A PostgreSQL or SQLite orm for Python
MIT License
22 stars 4 forks source link

add case-insensitive LIKE queries #118

Closed Jaymon closed 1 year ago

Jaymon commented 4 years ago

I think SQLite is case-insensitive by default, but PostgreSQL would need to do something like:

UPPER(<FIELD_NAME>) LIKE UPPER(%s)

You can see this in action with current case-insensitive functionality

Jaymon commented 1 year ago

I'm pretty sure this is solved with CITEXT support