Subject: Re: Regular Expressions
From: Guy Fraser <guy@incentre.net>
To: pgsql-sql@postgresql.org
In-Reply-To: <46013B89.4040603@fastcon.com.br>
References: <46013B89.4040603@fastcon.com.br>
Content-Type: text/plain
Organization: The Internet Centre
Date: Wed, 21 Mar 2007 08:36:46 -0600
Message-Id: <1174487806.26600.15.camel@sigurd.incentre.net>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Wed, 2007-03-21 at 11:04 -0300, Ezequias R. da Rocha wrote:
> Hi list,
> 
> I would like to know if postgresql has a Regular Expressions (Regex) 
> implemented already.
> 
> With it we could implement queries like
> 
> Select * from myClientes where name = 'E[zs]equias'
> 
Case Sensitive Regular Match ~
Case Insensitive Regular Match ~*
Negated Case Sensitive Regular Match !~
Negated Case Insensitive Regular Match !~*

Select * from myClientes where name ~ 'E[zs]equias'

> where the result occurs even if the field has Ezequias or Esequias.
> 
> Regards
> Ezequias
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 
-- 
Guy Fraser
Network Administrator
The Internet Centre
1-888-450-6787
(780)450-6787