Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A754F475AFA for ; Sat, 6 Jul 2002 02:46:00 -0400 (EDT) Mailbox-Line: From carmen_wai@yahoo.com Sat Jul 6 02:46:00 2002 Received: from web13401.mail.yahoo.com (web13401.mail.yahoo.com [216.136.175.59]) by postgresql.org (Postfix) with SMTP id A9C6547591A for ; Sat, 6 Jul 2002 02:45:11 -0400 (EDT) Message-ID: <20020706064512.37016.qmail@web13401.mail.yahoo.com> Received: from [210.6.30.48] by web13401.mail.yahoo.com via HTTP; Fri, 05 Jul 2002 23:45:12 PDT Date: Fri, 5 Jul 2002 23:45:12 -0700 (PDT) From: Carmen Wai Subject: Problem on PostgreSQL (error code, store procedures) To: pgadmin-support@postgresql.org, pgsql-sql@postgresql.org, pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=-1.9 required=5.0 tests=X_NOT_PRESENT version=2.30 X-Spam-Level: X-Archive-Number: 200207/6 X-Sequence-Number: 569 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