Re: trouble building user defined agg function with plpython

On Tue, 14 Jun 2011, Tom Lane wrote:

> 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

Thanks so much, I had missed that part in the docs about reassigning the
function parameters. That helped point me in the right direction.

Rick