Re: Case insensitive string comparison?

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Case insensitive string comparison?
Date: 2001-05-21 09:15:41
Message-ID: Pine.LNX.4.21.0105211214220.24294-100000@nanu.visionforisrael.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message tjk@tksoft.com 2001-05-21 11:53:45 Re: Case insensitive string comparison?
Previous Message Tod McQuillin 2001-05-21 08:54:02 Re: how to check presence of a function and set permissions?