Simple Question of Performance ILIKE or Lower

From: Marcos <mjs_ops(at)gmx(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Simple Question of Performance ILIKE or Lower
Date: 2006-01-18 09:10:30
Message-ID: 1137575430.966.10.camel@servidor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alessandro Baretta 2006-01-18 09:14:49 Re: Suspending SELECTs
Previous Message Tino Wildenhain 2006-01-18 09:08:25 Re: Suspending SELECTs