PostgreSQL Discussion - Perl regular expressions

Author

Perl regular expressions

2005-09-28, 8:24 pm

Is there any support for perl regular expressions
in Postgresql?

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

A. Kretschmer

2005-09-29, 9:24 am

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/curr...tic/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 ===

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sean Davis

2005-09-29, 9:24 am

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/...s-matching.html

Sean

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Tino Wildenhain

2005-09-29, 9:24 am

A. Kretschmer schrieb:
> am 28.09.2005, um 22:25:29 -0000 mailte ellis@no.spam folgendes:
>
>
>
> Yes, you can use perl regex in plperl.
> http://www.postgresql.org/docs/curr...tic/plperl.html

And in plpythonu too ;)

Part of that syntax is also useable in SQL regex.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

A. Kretschmer

2005-09-29, 11:23 am

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:
>
>
> You might want to look at this section of the documentation:
>
> http://www.postgresql.org/docs/8.0/...s-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 ===

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Scott Marlowe

2005-09-29, 11:23 am

On Thu, 2005-09-29 at 08:30, Tino Wildenhain wrote:
> A. Kretschmer schrieb:
>
> 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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Randal L. Schwartz

2005-09-29, 11:23 am

>>>>> "Scott" == Scott Marlowe < smarlowe@g2switchwor
ks.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!

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links