Ok, thank you very much. 2016-01-13 19:04 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> 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 >
