Postgres Pro
Downloads
Home   >   mailing lists

Thread: Perl regular expressions

Perl regular expressions

From
ellis@no.spam ()
Date:
Is there any support for perl regular expressions
in Postgresql?

--
http://www.spinics.net/yosemite/

Re: Perl regular expressions

From
Sean Davis
Date:
On 9/28/05 6:25 PM, "ellis@no.spam" <ellis@no.spam> wrote:

> Is there any support for perl regular expressions
> in Postgresql?

You might want to look at this section of the documentation:

http://www.postgresql.org/docs/8.0/interactive/functions-matching.html

Sean

Re: Perl regular expressions

From
"A. Kretschmer"
Date:
am  28.09.2005, um 22:25:29 -0000 mailte ellis@no.spam folgendes:
> Is there any support for perl regular expressions
> in Postgresql?

Yes, you can use perl regex in plperl.
http://www.postgresql.org/docs/current/static/plperl.html


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: Perl regular expressions

From
Tino Wildenhain
Date:
A. Kretschmer schrieb:
> am  28.09.2005, um 22:25:29 -0000 mailte ellis@no.spam folgendes:
>
>>Is there any support for perl regular expressions
>>in Postgresql?
>
>
> Yes, you can use perl regex in plperl.
> http://www.postgresql.org/docs/current/static/plperl.html

And in plpythonu too ;)

Part of that syntax is also useable in SQL regex.

Re: Perl regular expressions

From
"A. Kretschmer"
Date:
am  29.09.2005, um  9:14:39 -0400 mailte Sean Davis folgendes:
> On 9/28/05 6:25 PM, "ellis@no.spam" <ellis@no.spam> wrote:
>
> > Is there any support for perl regular expressions
> > in Postgresql?
>
> You might want to look at this section of the documentation:
>
> http://www.postgresql.org/docs/8.0/interactive/functions-matching.html

Right. But regex_replace are missing. This comes with 8.1. ;-)


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: Perl regular expressions

From
Scott Marlowe
Date:
On Thu, 2005-09-29 at 08:30, Tino Wildenhain wrote:
> A. Kretschmer schrieb:
> > am  28.09.2005, um 22:25:29 -0000 mailte ellis@no.spam folgendes:
> >
> >>Is there any support for perl regular expressions
> >>in Postgresql?
> >
> >
> > Yes, you can use perl regex in plperl.
> > http://www.postgresql.org/docs/current/static/plperl.html
>
> And in plpythonu too ;)
>
> Part of that syntax is also useable in SQL regex.

Hops on band wagon...

And you can use perl regex in PHP as well, since it supports the PCRE
lib.

Re: Perl regular expressions

From
merlyn@stonehenge.com (Randal L. Schwartz)
Date:
>>>>> "Scott" == Scott Marlowe <smarlowe@g2switchworks.com> writes:

Scott> And you can use perl regex in PHP as well, since it supports the PCRE
Scott> lib.

Well, *almost* Perl.  Despite its name, PCRE is a misnomer, since it's
not really Perl and it's not entirely compatible. :) Yes, it's a
powerful regular expression engine, but Perl regexen can still do some
common things that cannot be done with PCRE.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!