Re: [SQL] rowcount function in postgres???

2007-04-07 Thread Rodrigo De León
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

Re: [SQL] rowcount function in postgres???

2007-04-07 Thread Michael Fuhr
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.

[SQL] rowcount function in postgres???

2007-04-07 Thread Karthikeyan Sundaram
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