pl/perl Documentation

From: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: pl/perl Documentation
Date: 2002-05-22 11:43:14
Message-ID: 7DD34E6DF5CD1B4283DDAB96A855DCED2F336E@vodabemail1.vodacom.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all

I'm trying to find documentation for postgres/plperl.

the online postgres documentation has only two examples in it and i am
struggling to find any more that i can make sense of. also most of the
documents i find are about installing pl/perl. this i have done and tested
with the examples found in the online documentation.

i am a complete newbie to both perl and postgres functions, so the
documentation will almost have to have to draw pictures.

i am trying to build a function that strips whitespace.

with the following

CREATE or REPLACE FUNCTION remspace(TEXT) RETURN TEXT
AS '
@_ =~ s/\s*//;
return @_'
LANGUAGE 'plperl';

i keep getting:

parser: parse error at or near "return"

no matter what i do. i have a feeling this means that i have a syntax error
some where in the function, but can't figger out where. is there any way of
getting a more detailed error description?

duncan

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John Taylor 2002-05-22 13:45:36 optimising data load
Previous Message Josh Berkus 2002-05-22 04:14:20 Re: PostgreSQL+Access97+Linux: How to..