Re: [GENERAL] select LIKE

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
--------------------------------------------------------------------