| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-10-31 17:29:55 | Re: [INTERFACES] Case insensitive LIKE ? |
| Previous Message | Wim Ceulemans | 1999-10-31 16:31:08 | Re: [INTERFACES] Case insensitive LIKE ? |