LIKE vrs ~~ - Mailing list pgsql-sql

From T.J.Farrell
Subject LIKE vrs ~~
Date
Msg-id 000601bfcd9a$c39f06e0$2c3cfac1@oemcomputer
Whole thread Raw
Responses Re: LIKE vrs ~~  (Peter Eisentraut <peter_e@gmx.net>)
Re: LIKE vrs ~~  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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...





pgsql-sql by date:

Previous
From: "T.J.Farrell"
Date:
Subject: Update table: extract max(hour).
Next
From: qzhwjb@myhome.net
Date:
Subject: Ho Ho Ho !!! 6684