----- Original Message -----
From: Bart Ogryczak <bart(at)bart(dot)w-wa(dot)pl>
To: <pgsql-sql(at)postgreSQL(dot)org>
Sent: Thursday, August 12, 1999 4:24 PM
Subject: Re: [SQL] Searching Text Fields - Case Sensitive?
> > SELECT * FROM mydb WHERE description LIKE "%foobar%";
> > it seems to be case sensitive. Is there a way to do it so it is NOT
> > case-sensitive?
> SELECT * FROM mydb WHERE lower(description) LIKE "%foobar%";
Brings up an interesting question. Which is faster, to use the lower/upper
functions as above (and of course
if foobar is a variable, it would also have to be made lower case by the
program calling pgsql), or to use the pattern matching case-insensitive
operator?
Yours,
Moray