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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
