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

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

2016-01-13 16:47 GMT+01:00 lodopidolo <dir.postgresql@xxxxxxxxxxx>:

Hello. It is possible to call al PL/Python stored function natively from another PL/Python function?

The function created by CREATE OR REPLACE FUNCTION statement can be called only via special interface, or via SQL executor, so you cannot to call this function directly from Python

Pavel

 

Something like:

create or replace function f1() 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).