Re: trouble building user defined agg function with plpython

On Tue, 14 Jun 2011, Tom Lane wrote:

> 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

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