Limitations in PL/perl - Mailing list pgsql-general

From Josh Berkus
Subject Limitations in PL/perl
Date
Msg-id 200303181621.43638.josh@agliodbs.com
Whole thread Raw
Responses Re: Limitations in PL/perl  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Limitations in PL/perl  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Folks,

Is there any documentation anywhere on what subset of Perl functionality is
supported by PL/perl?   I've had a lot of annoying trial-and-error sessions
lately where I'll try something that works on the command line only to find
out that it silently fails in PL/perl.

For example:
On the command line:
$some_text =~ s/\W|\s//g;
... works great to remove all punctuation and spaces in a string.

But in PL/perl, I have to use:
$some_text =~ s/[^A-Za-z0-9]/""/eg;

Or is this maybe a problem with the version of Perl installed on the DB
server?

Thanks for any help.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Referential Integrity problem
Next
From: James Gregory
Date:
Subject: Re: Referential Integrity problem