Re: Case insensitive string comparison? - Mailing list pgsql-sql

From Cedar Cox
Subject Re: Case insensitive string comparison?
Date
Msg-id Pine.LNX.4.21.0105211214220.24294-100000@nanu.visionforisrael.com
Whole thread Raw
In response to Re: Case insensitive string comparison?  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: Case insensitive string comparison?  (Karel Zak <zakkr@zf.jcu.cz>)
Re: Case insensitive string comparison?  ("tjk@tksoft.com" <tjk@tksoft.com>)
List pgsql-sql
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...

-Cedar



pgsql-sql by date:

Previous
From: Tod McQuillin
Date:
Subject: Re: how to check presence of a function and set permissions?
Next
From: Jan Wieck
Date:
Subject: Re: HELP: what's wrong with my PL/PSQL function??