Re: Call postgres PL/Python stored function from another PL/Python block. - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Call postgres PL/Python stored function from another PL/Python block.
Date
Msg-id CAFj8pRDRd6Knub2rQ30WenCt=WmvAd7_oYyUaBxUHfVnRJJDmg@mail.gmail.com
Whole thread Raw
In response to Call postgres PL/Python stored function from another PL/Python block.  (lodopidolo <dir.postgresql@orencio.org>)
List pgsql-general
Hi

2016-01-13 16:47 GMT+01:00 lodopidolo <dir.postgresql@orencio.org>:
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.


pgsql-general by date:

Previous
From: "Igal @ Lucee.org"
Date:
Subject: Re: plv8 binaries for PostgreSQL 9.5 on Windows
Next
From: "Joshua D. Drake"
Date:
Subject: Re: WIP: CoC V5