Re: Method to detect certain characters in column? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Method to detect certain characters in column?
Date
Msg-id 20080623214739.GB4254@alvh.no-ip.org
Whole thread Raw
In response to Re: Method to detect certain characters in column?  (Antonio Perez <renjin25@yahoo.com>)
List pgsql-general
Antonio Perez wrote:

> example
>
> SELECT name FROM  table1 where name
>       ~* '*Ã*'

Actually this regex is flawed.  It looks like a common shell "glob"
pattern (I don't know the real name of these things), which is a very
different and simpler animal from a regex.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Antonio Perez
Date:
Subject: Re: Method to detect certain characters in column?
Next
From: Tom Lane
Date:
Subject: Re: Method to detect certain characters in column?