From: Jie Liang <jliang@ipinc.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to execute a C program via trigger ?
Date: Thu, 07 Dec 2000 15:01:56 -0800
Message-ID: <3A3016E4.433B5CAD@ipinc.com> (raw)
References: <20001204084729.45208.qmail@web10402.mail.yahoo.com>
Hi,
Is any other SQL implicit cursor attribute in PL/plsql ??
when you say (in pl/plsql):
select field into v_1 from atable where whatever;
special variable FOUND can be used to tell return is null or not.
this functions like SQL%FOUND or SQL%NOTFOUND in Oracle,
however, when I do some DML(insert,delete,update), is there any other
special variable can tell me howmany success. Like SQL%ROWCOUNT in Orcale??
And if there is an error such as : cannot insert since duplicate key on an
unique index, is it possible to catch it??
Thanks.
--
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.ipinc.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jliang@ipinc.com
Subject: Re: how to execute a C program via trigger ?
In-Reply-To: <3A3016E4.433B5CAD@ipinc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox