Postgres Pro
Downloads
Home   >   mailing lists

Re: [INTERFACES] Case insensitive LIKE ? - Mailing list pgsql-interfaces

From Constantin Teodorescu
Subject Re: [INTERFACES] Case insensitive LIKE ?
Date
Msg-id 381D36F1.72C6F912@flex.ro
Whole thread Raw
In response to Case insensitive LIKE ?  (Constantin Teodorescu <teo@flex.ro>)
List pgsql-interfaces
Tree view 
Wim Ceulemans wrote:
> 
> The case insensitive equivalent in postgreSQL is:
> 
>         select ~* 'john'
> 

I know that, I'm using on PostgreSQL the regexp search but I would like
to unify also the SQL commands.

-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

pgsql-interfaces by date:

Previous
From: "Lakshmi Anand K."
Date:
Subject: Updatable Dynasets
Next
From: "David D.W. Downey"
Date:
Subject: SUBSCRIBE