Re: Case insensitive string comparison? - Mailing list 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@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz