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

Re: [INTERFACES] Case insensitive LIKE ?

From: "Moray McConnachie" <moray(dot)mcconnachie(at)computing-services(dot)oxford(dot)ac(dot)uk>
To: "Constantin Teodorescu" <teo(at)flex(dot)ro>
Cc: "PostgreSQL Interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Date: 1999-10-31 17:01:49
Message-ID: 001901bf23c1$a018bfa0$01c8a8c0@malthouse.private.net (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 ..

Why not use Passthrough queries in Access/ODBC, which have pgsql do the SQL
for them and therefore use pgsql's syntax?

Or do you mean that the you are running Access and pgsql both as servers,
rather than Access as front-end?


In response to

pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-10-31 17:29:55
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Previous:From: Wim CeulemansDate: 1999-10-31 16:31:08
Subject: Re: [INTERFACES] Case insensitive LIKE ?

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