Hi Tony,
I'm trying to search case insensitive in PostgreSQL. Postgresql doesn't allow you to make text searching case insensitive.
You have to resort to either citext or lower/upper functions in your query. I don't like any of the options.
Radicore isn't allowing the syntax of postgresql lower function in combination with a LIKE.
It also doesn't recognize the 'ILike' operator.
The following throws a "Cannot extract token from:'%hello%'" error:
$where = "lower(product_name) LIKE '%hello%'";
'product_name' is a column in the database.
Seems to happen in the where2indexArray function from include.library.inc
It does however work with the '=' operator.
$where = "lower(product_name) = '%hello%'";
Of course the wild cards wouldn't work.
Tree questions:
1. How can I fix this?
2. Is there another way I can do case insensitive searching on texts in Radicore with pgsql?
3. Is there a way to hook into the default search to change the query to wrap the column name with lowar?
Radicore Forum
Search
Help
Members
Register
Login
Home
