X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2C0F4D1B45F for ; Tue, 23 Dec 2003 05:18:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40709-02 for ; Tue, 23 Dec 2003 01:17:27 -0400 (AST) Received: from Gateway.bksys.co.in (unknown [61.3.252.135]) by svr1.postgresql.org (Postfix) with ESMTP id 0B327D1B436 for ; Tue, 23 Dec 2003 01:17:25 -0400 (AST) Received: from bksys.co.in (mail.bksys.co.in [192.168.1.1]) by Gateway.bksys.co.in (8.11.6/8.11.6) with ESMTP id hBN5HM927453; Tue, 23 Dec 2003 10:47:22 +0530 Received: from Bhuvan.bksys.co.in (Bhuvan.bksys.co.in [192.168.1.71]) by bksys.co.in (8.11.6/8.8.5) with ESMTP id hBN5HLI04163; Tue, 23 Dec 2003 10:47:21 +0530 Subject: Re: From: "A.Bhuvaneswaran" To: sundaresan raman Cc: pgsql-sql@postgresql.org In-Reply-To: <20031222103043.50050.qmail@web41006.mail.yahoo.com> References: <20031222103043.50050.qmail@web41006.mail.yahoo.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-9icBhvy4ZCqMguUl++F5" Message-Id: <1072156931.1410.6.camel@Bhuvan.bksys.co.in> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 23 Dec 2003 10:52:14 +0530 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/160 X-Sequence-Number: 16326 --=-9icBhvy4ZCqMguUl++F5 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > I am new of postgre sql.im using cursors in pgsql and > getting tuples successfully returns in c++, but how > can i raise exception in the stored function?.pl > anyone help me. You can use 'raise exception' for this purpose. Refer this link for details: http://www.postgresql.org/docs/current/interactive/plpgsql-errors-and-messa= ges.html regards, bhuvaneswaran --=-9icBhvy4ZCqMguUl++F5 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA/59ECL2UFujVh8ToRAoB3AJ0ariBnqvbpJeD5Zyn2l2w71zugQACeMnN8 I/JAHvAQeV9zRfRr5vzrtwQ= =n1MR -----END PGP SIGNATURE----- --=-9icBhvy4ZCqMguUl++F5--