+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Postgresql ILIKE function (/showthread.php?tid=10697)
Postgresql ILIKE function - El Forum - 08-08-2008
[eluser]Unknown[/eluser]
As we know, PostgreSQL has the function like CASE SENSITIVE, so we cannot retrieve results if they are wrong spelled. So i suggest the implementation of ILIKE method in CodeIgniter postgres DB driver. I've putted in my installation a copy of like method implementing the ILIKE function. It works to me, but i think the basic PostgreSQL functions must be implemented in the driver.
Regards.
Postgresql ILIKE function - El Forum - 10-05-2010
[eluser]stuckinphp[/eluser]
Bump, apparently this bright idea was ignored.
The simplest solution for most people will be to override the _like function with your own that replaces LIKE with ILIKE - it only makes it more so like the other db's likes anyway.