IgnitedDatatables/Ignited-Datatables — Issue #12: Error with LIKE in postgresql
Author: epallerols
Created: 2012-02-29 15:35:28+00:00
State: open

When you try to perform a search the query fails if the selected column it's not a string.
LIKE pattern matching in postgresql only accept strings types

I solved my issue casting the field to varchar at line 228.

$sWhere .= $this->select[$mColArray[$i]] . "::varchar LIKE '%" . $sSearch . "%' OR ";

This fix works only for postgresql and it must be implemented differently in order to fix this issue