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

[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 values (1);
      if sql%rowcount > 0
      then
        dbms.output.put_line('rows inserted');
      else
        dbms.output.put_line('rows not inserted');
     end if;
 end;

 Is there something equal to sql%rowcount in postgres?   Please help.

 Regards
 skarthi

Maybe:

http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings