Ok, thank you very much.
2016-01-13 19:04 GMT+01:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 01/13/2016 07:47 AM, lodopidolo wrote:
Hello. It is possible to call al PL/Python stored function natively from
another PL/Python function?
Something like:
|createorreplace functionf1()returns text as$$return"hello"$$language
'plpython3u';|
|do $$begin...t =f1()...end;$$language 'plpython3u';|
Regards.
(this question has been made in
http://stackoverflow.com/questions/34764665/call-postgres-pl-python-stored-function-from-another-pl-python-block
too).
In addition to the other answers there is the option of just creating the function in a Python module outside Postgres and doing:
from some_module import f
Which would seem to address this(from the SO post):
"This can be done using t = plpy.execute("select f1()"), but I want, if it is possible, call it as a normal Python function to avoid type conversions (for example jsonb, etc)."
The downside being you have a dependency outside the database.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
