On 23 January 2017 at 19:37, Rouzzi Anissa <rouzzi.anissa@gmail.com> wrote:
> I need to override Like Operator because it's sensitive case, how could i achieve that?
From https://www.postgresql.org/docs/current/static/functions-matching.html:
"The key word ILIKE can be used instead of LIKE to make the match
case-insensitive according to the active locale. This is not in the
SQL standard but is a PostgreSQL extension."
Binand