Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Case insensitive LIKE ?

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Date: 1999-10-31 12:30:29
Message-ID: 381C3665.572E14EF@flex.ro (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hannu Krosing wrote:
> 
> Constantin Teodorescu wrote:
> >
> > Is there for PostgreSQL a modifier(parameter) that will make the LIKE
> > clause case insensitive ?
> 
> Maybe
> 
>  select * from t where lower(name) like 'john%';

Yes, it may work, but probably lower(name) won't work on ODBC->MS Access
...
I would like to preserve also the SQL commands betwen versions and not
to fill my program with IF's ..

-- 
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

In response to

Responses

pgsql-interfaces by date

Next:From: Hannu KrosingDate: 1999-10-31 12:35:47
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Previous:From: Constantin TeodorescuDate: 1999-10-31 12:10:16
Subject: Case insensitive LIKE ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group