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