Horton

Re: [GENERAL] select LIKE

Kevin Heflin <kheflin@shreve.net>

View thread View on postgr.es
From: Kevin Heflin <kheflin@shreve.net>
To: David Hartwig <daybee@bellatlantic.net>
Cc: "PGSQL-General (E-mail)" <pgsql-general@postgreSQL.org>
Date: 1998-09-04T03:38:14Z
Lists: pgsql-general 
On Thu, 3 Sep 1998, David Hartwig wrote:

> > First question: is there a way to do this that is NOT case sensitive?> 
> Use the case insensitive regular expression operator.
>     select * from rolodex where name ~* '.*$name.*'


Thanks! that solved both my problems.

Is this regular SQL or something more specific to PostgreSQL ?


The SQL book I looked through didn't show anything like this ~*

Kevin



--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------