On 19/02/10 05:42, Yan Cheng Cheok wrote:
>
> Of course, I get an error at line :
> IF @@ROWCOUNT=0 THEN
>
> May I know what is the correct PostgreSQL syntax for @@ROWCOUNT after update?
Best place for this sort of information is the manuals:
http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
GET DIAGNOSTICS my_variable = ROWCOUNT;
--
Richard Huxton
Archonet Ltd