Re: Call postgres PL/Python stored function from another PL/Python block.

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@aklaver.com