From: | Nicola(dot)Scioscia(at)ascot(dot)tn(dot)it |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | plperlu function |
Date: | 2005-12-05 09:40:34 |
Message-ID: | OFAA3038A2.D456CD80-ONC12570CE.0032FBE6-C12570CE.00352713@ascot.tn.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
I am an absolute beginner in postgres and apologize in advance for a
possible silly question.
I am running postgreSQL 8.0 on a Suse Linux box
I need to write a function in a postgres database that performs an
extraction on three archives and writes the extracted records in a text
file.
I added the support for the "plperlu" language. I have defined the
function in the following way:
CREATE FUNCTION sampleExtraction() RETURNS boolean AS $$
// function implementation
$$ LANGUAGE plperlu IMMUTABLE STRICT;
I will launch this function manually when needed. My questions are:
- is this feasible in this way ?
- how can I launch/execute the function? Do I need to write a suitable
SELECT or is there an alternative way? Is "SELECT sampleExtraction();"
correct?
Thanks in advance for your kind help
Best regards
Nicola Scioscia
From | Date | Subject | |
---|---|---|---|
Next Message | Maik Troemel | 2005-12-05 09:40:46 | PG_exception_stack |
Previous Message | William Bug | 2005-12-05 08:57:24 | Re: tool for DB design |