From: | Stephen Howard <stephen(at)thunkit(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | plperlu and 'use' statement scope question |
Date: | 2004-02-09 16:49:51 |
Message-ID: | 4027BA2F.7080100@thunkit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello list,
I'm designing a plperlu function and i was wondering about scoping on
use statements for external libraries. I couldn't find any information
on it in the documentation or in the mail archives, so any information
would be much appreciated.
The function is intended to be used as part of a select statement:
select foo,my_function(bar) as baz from table where baz > some_value
order by baz
And the function uses an external module to do much of the heavy
lifting. What I'm wondering is will the function have to reload the
external module for every row, or is plperlu smart enough to only load
it once for the entire query? In the other extreme, I'm hoping that it
does reload the external module for each query, as I expect to be
dynamically rewriting one of the modules that that external module requires.
-Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Wei Wang | 2004-02-09 16:52:30 | newbie pl/pgsql question on trigger function error |
Previous Message | Doug McNaught | 2004-02-09 16:44:16 | Re: Quad Xeon vs. Dual Itanium |