On 4/7/07, Karthikeyan Sundaram <[EMAIL PROTECTED]> wrote:
Hi,
I am using 8.1.0 postgres and trying to write a plpgsql block. In that
I am inserting a row. I want to check to see if the row has been inserted
or not.
In oracle we can say like this
begin
insert into table_a
On Sat, Apr 07, 2007 at 10:33:19AM -0700, Karthikeyan Sundaram wrote:
> I am using 8.1.0 postgres and trying to write a plpgsql block.
8.1.8 is the latest version in that branch. Read the Release Notes
for each minor release to see what bug fixes you're missing.
http://www.postgresql.org/docs/8.
Hi,
I am using 8.1.0 postgres and trying to write a plpgsql block. In that I am
inserting a row. I want to check to see if the row has been inserted or not.
In oracle we can say like this
begin
insert into table_a values (1);
if sql%rowcount > 0
then
dbms.out