agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Guy Fraser <guy@incentre.net>
To: pgsql-sql@postgresql.org
Subject: Re: Regular Expressions
Date: Wed, 21 Mar 2007 08:36:46 -0600
Message-ID: <1174487806.26600.15.camel@sigurd.incentre.net> (raw)
In-Reply-To: <46013B89.4040603@fastcon.com.br>
References: <46013B89.4040603@fastcon.com.br>
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
view thread (18+ messages) latest in thread
Message-ID: <1174487806.26600.15.camel@sigurd.incentre.net>
Permalink: ../1174487806.26600.15.camel@sigurd.incentre.net/
Also on: postgresql.org/message-id/1174487806.26600.15.camel@sigurd.incentre.net
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: guy@incentre.net
Subject: Re: Regular Expressions
In-Reply-To: <1174487806.26600.15.camel@sigurd.incentre.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox