From: | "Ezequias R(dot) da Rocha" <ezequias(at)fastcon(dot)com(dot)br> |
---|---|
To: | Guy Fraser <guy(at)incentre(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Regular Expressions |
Date: | 2007-03-21 17:37:07 |
Message-ID: | 46016D43.9030300@fastcon.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guido Neitzer | 2007-03-21 17:37:44 | Re: growth of the database |
Previous Message | Karthikeyan Sundaram | 2007-03-21 17:25:51 | growth of the database |