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

You can index the lower(...) queries, but you can't for the
regex queries.


Troy

> 
> 
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
>