I am using a PL/pgSQL procedure. I am trying to hold the procedure
name in a table and then based on certain selection criteria get the
procedure name out of the table and execute it. I would like to pass a
row record, currently NEW, and retrieve the same rowtype. The
following code will compile but yields the result below it for either
of the two statements listed. Note that the procedure is triggered
from an insert running from a Perl script.
EXECUTE '"RuleRec.rule_procedure_name"(NEW)' INTO NEW;
or
NEW := "RuleRec.rule_procedure_name"(NEW);
Result:
DBD::Pg:st execute failed: ERROR: operator does not exist: money <>
integer
HINT: No operator matches the given name and argument type(s). You may
need to add explicit type casts.
CONTEXT: SQL statement "SELECT (( $1 - $2 - $3 - $4 - $%) <> 0)"
Can you help me code this correctly and, if possible, explain what's
happening here?
PG Ver: 8.1.3
DBD Ver: 1.48
Thanks.
Robert Young