LIKE vrs ~~

From: "T(dot)J(dot)Farrell" <T(dot)J(dot)Farrell(at)wanadoo(dot)fr>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: LIKE vrs ~~
Date: 2000-06-03 20:31:07
Message-ID: 000601bfcd9a$c39f06e0$2c3cfac1@oemcomputer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I was wondering about the performance incidence of :

SELECT * FROM table1 WHERE UPPER(field1) LIKE
UPPER('%thomas%');

versus:

SELECT * FROM table1 WHERE field1 ~~ '%thomas%'

if any...

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message qzhwjb 2000-06-04 00:24:50 Ho Ho Ho !!! 6684
Previous Message T.J.Farrell 2000-06-03 20:02:43 Update table: extract max(hour).