Обсуждение: Perl regular expressions
Is there any support for perl regular expressions in Postgresql? -- http://www.spinics.net/yosemite/
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.
>>>>> "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!