From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Case insensitive string comparison? |
Date: | 2001-05-21 13:01:00 |
Message-ID: | 20010521150059.A5076@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Mon, May 21, 2001 at 12:15:41PM +0300, Cedar Cox wrote:
>
> On Tue, 15 May 2001, Karel Zak wrote:
>
> > On Tue, May 15, 2001 at 02:48:24PM +0200, Borek Lupom?ský wrote:
> > > Is there an operator for case insensitive string comparison, or
> > > should I use regular expression matching with ~* '^string$'?
> >
> > possibility:
> >
> > - use upper() / lower() inside query
>
> Ok, this is probably a really silly question: which is faster?
> I expect they are nearly identical code. Just wondering...
>
Only one answer will be right ... try all possibility :-)
IMHO the 'ILIKE' is the most fast, because it's simple for parser and
it's one function.
Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
From | Date | Subject | |
---|---|---|---|
Next Message | LeoDeBeo | 2001-05-21 13:50:54 | c++ wrapper library |
Previous Message | Jan Wieck | 2001-05-21 12:48:23 | Re: HELP: what's wrong with my PL/PSQL function?? |