Re: [NOVICE] Override Like Operator - Mailing list pgsql-novice

From Binand Sethumadhavan
Subject Re: [NOVICE] Override Like Operator
Date
Msg-id CAFBJCCY46+KRq5d21=6cET00XG4rtGBqQdg=irCGxESD+1SbHQ@mail.gmail.com
Whole thread Raw
In response to [NOVICE] Override Like Operator  (Rouzzi Anissa <rouzzi.anissa@gmail.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Rouzzi Anissa
Date:
Subject: [NOVICE] Override Like Operator
Next
From: Moreno Andreo
Date:
Subject: Re: [SPAM] [NOVICE] Override Like Operator