Limitations in PL/perl

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Limitations in PL/perl
Date: 2003-03-19 00:21:43
Message-ID: 200303181621.43638.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Moore-Oliva 2003-03-19 00:32:48 Division of intervals.
Previous Message Stephan Szabo 2003-03-19 00:08:04 Re: Referential Integrity problem