Re: [SPAM] Override Like Operator

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