From: Moray McConnachie <moray.mcconnachie@computing-services.oxford.ac.uk>
To: Constantin Teodorescu <teo@flex.ro>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Date: Sun, 31 Oct 1999 17:01:49 -0000
Message-ID: <001901bf23c1$a018bfa0$01c8a8c0@malthouse.private.net> (raw)
References: <381C31A8.34A17B8E@flex.ro>
<381C37A3.EC9D5D4D@tm.ee>
<381C3665.572E14EF@flex.ro>
> 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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: moray.mcconnachie@computing-services.oxford.ac.uk, teo@flex.ro
Subject: Re: [INTERFACES] Case insensitive LIKE ?
In-Reply-To: <001901bf23c1$a018bfa0$01c8a8c0@malthouse.private.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox