Updated rowcount

From: "Jason Alexander" <jason-alexander(at)home(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Updated rowcount
Date: 2001-07-04 16:42:52
Message-ID: 9hvh2m$3cn$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message penny 2001-07-04 17:49:44 sql startment problem PLEASE HELP .....
Previous Message Raghavendra 2001-07-04 13:18:06 Problem in running the postmaster