"Daniel Hutchison" <Daniel.Hutchison@rokaconsulting.com> writes:
> I've been experiencing problems getting any plperl function working, and I
> believe the problem lies in the actual plperl installation not due to my
> rusty perl memories. For example, the very simple plperl example in the
> comprehensive documentation (at
> http://www.postgresql.org/docs/8.4/interactive/plperl-funcs.html):
> Returns something odd (at least to me, also with little postgresql
> experience):
> prod1=> select perl_max(1,2);
> ERROR: invalid input syntax for integer: "CODE(0x1f6d13c)"
I'm going to guess that your perl installation doesn't match the version
of perl your postgresql installation was built against. I'm not sure
how you find that out for certain, but maybe the docs that came with the
PG installer would tell you what it's expecting.
regards, tom lane