Postgres Pro
Downloads
Home   >   mailing lists

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

From Moreno Andreo
Subject Re: [SPAM] [NOVICE] Override Like Operator
Date
Msg-id 36f85e89-2bb3-19fc-c7c3-e658dd38ecbd@evolu-s.it
Whole thread Raw
In response to [NOVICE] Override Like Operator  (Rouzzi Anissa <rouzzi.anissa@gmail.com>)
List pgsql-novice
Tree view 
Il 23/01/2017 15:07, Rouzzi Anissa ha scritto:
> Hi,
>
> I need to override Like Operator because it's sensitive case, how
> could i achieve that?
>
use upper()
https://www.postgresql.org/docs/9.1/static/functions-string.html

i.e.
select foo from bar where upper(foobar) like '%BLAH%';

HTH
Moreno

> Thanks a lot
> --
> -- Cordialement
> -- ROUZZI Anissa

pgsql-novice by date:

Previous
From: Binand Sethumadhavan
Date:
Subject: Re: [NOVICE] Override Like Operator
Next
From: valeriof
Date:
Subject: [NOVICE] Deployment of an output plugin in Unix-like environment