Re: trouble building user defined agg function with plpython - Mailing list pgsql-general

Rick Harding <rharding@mitechie.com> writes:
> CREATE OR REPLACE FUNCTION mysum(curr integer, vals group_data)
>  RETURNS integer
>  AS $$
>     try:
>         curr = curr + vals['weight']
>     except UnboundLocalError:
>         plpy.notice("UNBOUND")
>         curr = 0
>     return curr
>  $$ LANGUAGE plpythonu;

This function doesn't work when called manually; it's got nothing to do
with the aggregate context.  You should read the last half of this page:

http://www.postgresql.org/docs/9.0/static/plpython-funcs.html

            regards, tom lane