From: Tom Lane <tgl@sss.pgh.pa.us>
To: Moray McConnachie <moray.mcconnachie@computing-services.oxford.ac.uk>
Cc: Constantin Teodorescu <teo@flex.ro>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Date: Sun, 31 Oct 1999 12:29:55 -0500
Message-ID: <20300.941390995@sss.pgh.pa.us> (raw)
In-Reply-To: <001901bf23c1$a018bfa0$01c8a8c0@malthouse.private.net>
"Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk> writes:
>> 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?
I think he just would rather avoid depending on unportable features,
which is a perfectly reasonable thing to want to do.
However, AFAICS there isn't any direct notion of "case insensitive LIKE"
in SQL92, so he's going to have to depend on *something* that's not in
the spec.
What the spec seems to envision is that you get this result by attaching
a case-insensitive collation spec to the column you're going to do the
LIKE on --- in other words, the meaning of "foo LIKE 'bar'" depends on
the charset and collation attributes of the foo column. If you want
something other than what the column was set up to provide, tough
cookies. Seems a tad brain-dead to me. Anyway, there's no such concept
in Postgres, and I'll bet M$ doesn't do it exactly that way either...
regards, tom lane
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: tgl@sss.pgh.pa.us, moray.mcconnachie@computing-services.oxford.ac.uk, teo@flex.ro
Subject: Re: [INTERFACES] Case insensitive LIKE ?
In-Reply-To: <20300.941390995@sss.pgh.pa.us>
* 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