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
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.. |