| 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: | Whole Thread | Raw Message | 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.. |