Re: trouble building user defined agg function with plpython

Rick Harding <rharding(at)mitechie(dot)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