Hello, I would like to know if there are any global variables storing the error code or the number of rows affected after each execution of the SQL statement.
Also, for Postgresql function, I have checked that I can only call the function by: select function(parms) or by EXECUTE PROCEDURE function(parms) in the trigger action. I wonder whether there is any other method for calling the function which is similar to the stored procedures in the MS SQL server? Thank a lot! Carmen __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]