Re: Limitations in PL/perl

Josh Berkus <josh@agliodbs.com> writes:
> 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;

AFAIK, either of these should work in plperl.  Did you remember to
double those backslashes while entering the function text?

            regards, tom lane