[GENERAL] dynamic procedure call

2008-05-09 Thread tekwiz
How do I code PL/pgSQL to select a procedure name from a table and then execute it from within another procedure and pass that procedure a particular ROWTYPE and return a ROWTYPE? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://ww

[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