On Tue, 14 Jun 2011, Tom Lane wrote:
> Rick Harding <rharding@xxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
