[GENERAL] Variables inside plpythonu

[Frank Lanitz]

Hi folks, 

I did check the documentation but seem to didn't found the best way to
use plpythonu with a variable inside a query. 
Let's say I want to run this query 
SELECT id FROM some_table WHERE date=<date_from_function_call>
How a CREATE FUNCTION stateent have to look like? 
I already figured out that the python code should look similar to 

plan = plpy.prepare("SELECT id FROM some_table WHERE date=???? 
return = plpy.execure(plan)

But somehow a last piece is missing. 

Can anybody help?

Cheers, 
Frank
-- 
Frank Lanitz <fr...@frank.uvena.de>

pgprKWy6SHnPI.pgp
Description: PGP signature