Updated rowcount - Mailing list pgsql-sql

From Jason Alexander
Subject Updated rowcount
Date
Msg-id 9hvh2m$3cn$1@news.tht.net
Whole thread Raw
List pgsql-sql
Hello all,


I'm attempting to find the property (if it exists) where I can check to see
how many rows were affected during an UPDATE. An equivalent would be
@@ROWCOUNT in SQL Server, etc...

As an example:

UPDATE tablefoo
SET foo1 = 'spork'
WHERE foo2 = 'goomba'

IF @@ROWCOUNT = 0 INSERT INTO tablefoo . . . .

And, so on...

TIA,
-Jason




pgsql-sql by date:

Previous
From: "Raghavendra"
Date:
Subject: Problem in running the postmaster
Next
From: "Josh Berkus"
Date:
Subject: Help! Failure of pgdump -a