Home > mailing lists

Equivalent to sql%rowcount or @@rowcount - Mailing list pgsql-sql

From	vijaykumar M
Subject	Equivalent to sql%rowcount or @@rowcount
Date	July 25, 2003 03:07:25
Msg-id	BAY2-F55DEJmGzrLCCt00001fb2@hotmail.com Whole thread Raw
Responses	Re: Equivalent to sql%rowcount or @@rowcount
List	pgsql-sql

Hi All!

is it possible to get in sql number of rows affected by the sql last insert,

update or delete statement??

for eg,

oracle ------------- sql%rowcount.

sqlserver ------------ select @@rowcount.

Any help will be highly appreciated..

Thanks

Regards,

Vijay

Cool new emoticons. Lots of colour! On MSN Messenger V6.0

From: Dan Weeks
Date: 24 July 2003, 20:31:34
Subject: Re: silly NULL question

From: Richard Huxton
Date: 25 July 2003, 05:05:38
Subject: Re: Equivalent to sql%rowcount or @@rowcount