Home > mailing lists

Simple Question of Performance ILIKE or Lower - Mailing list pgsql-performance

From	Marcos
Subject	Simple Question of Performance ILIKE or Lower
Date	January 18, 2006 10:15:32
Msg-id	1137575430.966.10.camel@servidor Whole thread Raw
Responses	Re: Simple Question of Performance ILIKE or Lower
List	pgsql-performance

Tree view

Hi,

I have a simple question about performance using two resources.

What's have the best performance?

lower( col1 ) LIKE lower( 'myquestion%' )

OR

col1 ILIKE 'myquestion%'

Thanks.

pgsql-performance by date:

From: Alessandro Baretta
Date: 18 January 2006, 08:14:38
Subject: Re: Suspending SELECTs

From: J@Planeti.Biz
Date: 18 January 2006, 13:06:10
Subject: Re: Multiple Order By Criteria

Simple Question of Performance ILIKE or Lower - Mailing list pgsql-performance

Previous

Next