Re: [GENERAL] Executing dynamic procedure call

2008-05-03 Thread Craig Ringer
tekwiz wrote: 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)" craig=# SELECT '0'::money

[GENERAL] Executing dynamic procedure call

2008-05-03 Thread tekwiz
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 bu