calling Postgresql stored procedure

[Weinhandl Herbert]

Alchemist schrieb:
> I am using Python 2.4 and Postgresql 8.2 database server.
> 
> On the database I have created a stored function, example,
> CREATE OR REPLACE FUNCTION calculateaverage()
> 
> I created a new python script and would like to call my database
> stored function.
> 
> How can I call a database stored function/procedure in python?
> 

with :

     SELECT calculateaverage() FROM ... WHERE ... ;

happy pythoning

Herbert