Perl regular expressions

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

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 ===

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.

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 ===

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.