On Tue, 2005-03-08 at 16:30 -0600, Guy Rouillier wrote: > We use a dynamic statement in a pgsql stored function to insert rows > into a table determined at run time. After much debugging, I've > discovered that a null incoming argument will cause the dynamic > statement to evaluate to null. The error message emitted is "unable to > execute null statement." can't you use COALESCE() ? gnari ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)