Re: Limitations in PL/perl - Mailing list pgsql-general

From Tom Lane
Subject Re: Limitations in PL/perl
Date
Msg-id 4140.1048050947@sss.pgh.pa.us
Whole thread Raw
In response to Limitations in PL/perl  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Limitations in PL/perl  (Josh Berkus <josh@agliodbs.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert aliases?
Next
From: Josh Berkus
Date:
Subject: Re: Limitations in PL/perl