Message-ID: <46016D43.9030300@fastcon.com.br>
Date: Wed, 21 Mar 2007 14:37:07 -0300
From: "Ezequias R. da Rocha" <ezequias@fastcon.com.br>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: Guy Fraser <guy@incentre.net>
CC: pgsql-sql@postgresql.org
Subject: Re: Regular Expressions
References: <46013B89.4040603@fastcon.com.br>
	<1174487806.26600.15.camel@sigurd.incentre.net>
In-Reply-To: <1174487806.26600.15.camel@sigurd.incentre.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Guy Fraser escreveu:
> 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
>>
>>     
Great I am thinking of putting my like to rest. I felt it faster than 
"like" statement, have you any information about that ?

Ezequias