Re: [GENERAL] select LIKE

Kevin Heflin wrote:

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

This is what happens when you put SQL source code in the hand of a bunch of
Unix hacks. I am mot aware of this operator in any other dialect of SQL.

BTW, do a "\do" in psql to get a list of operators. You may see a few that
may be interesting.