Re: Override Like Operator

From: Binand Sethumadhavan <binand(at)gmx(dot)net>
To: Rouzzi Anissa <rouzzi(dot)anissa(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Override Like Operator
Date: 2017-01-23 14:30:13
Message-ID: CAFBJCCY46+KRq5d21=6cET00XG4rtGBqQdg=irCGxESD+1SbHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 23 January 2017 at 19:37, Rouzzi Anissa <rouzzi(dot)anissa(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Moreno Andreo 2017-01-23 14:31:36 Re: [SPAM] Override Like Operator
Previous Message Rouzzi Anissa 2017-01-23 14:07:03 Override Like Operator