Received: from mail.com-stock.com (mail.com-stock.com [204.255.137.254]) by postgresql.org (Postfix) with ESMTP id 75689476E09 for ; Wed, 27 Feb 2002 14:09:17 -0500 (EST) Received: by mail.com-stock.com (Postfix, from userid 1000) id 03FE195; Wed, 27 Feb 2002 14:06:27 -0500 (EST) Received: from deimos (deimos.com-stock.com [204.255.137.120]) by mail.com-stock.com (Postfix) with SMTP id 6F0D0D9EE; Wed, 27 Feb 2002 14:06:26 -0500 (EST) Message-ID: <002f01c1bfc2$ecaa02d0$7889ffcc@comstock.com> From: "Gregory Wood" To: "Samuel J. Sutjiono" Cc: "PostgreSQL-General" References: <00f701c1bfa4$f19b67c0$110a010a@headquarters.wcgroup.com> Subject: Re: System Messages Date: Wed, 27 Feb 2002 14:14:02 -0500 Organization: Comstock Net Services MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Archive-Number: 200202/1361 X-Sequence-Number: 21351 If there is an error, it should throw an exception that will stop the function. On the other hand, if you set a where clause on that UPDATE, then it might not actually modify any existing rows. In that case you can check the ROW_COUNT from GET DIAGNOSTICS to see if it modified any records (and however many). For more information on GET DIAGNOSTICS, check out: http://www7.us.postgresql.org/users-lounge/docs/7.2/postgres/plpgsql-stateme nts.html#PLPGSQL-STATEMENTS-DIAGNOSTICS Greg ----- Original Message ----- From: Samuel J. Sutjiono To: pgsql-sql@postgresql.org ; pgsql-general@postgresql.org Sent: Wednesday, February 27, 2002 10:39 AM Subject: [GENERAL] System Messages I have a function (stored procedures) that updates or inserts a customer record (see below). IF found then Update Customer Set custname = icustname retmsg := ''record already exists - updated''; ELSE Insert into Customer (custname) VALUES (icustname); retmsg := ''successful''; END IF; Can anybody tell me how I can be sure that the record is updated or inserted into the database ? Is there any system message in PostgreSQL that I can query ? Thanks for your help.