[PERFORM] Simple Question of Performance ILIKE or Lower

[Marcos]

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.



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster