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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
