Postgres Pro
Downloads
Home   >   mailing lists

Re: getting the number of rows affected by a query - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: getting the number of rows affected by a query
Date
Msg-id 473D923B.7000902@iol.ie
Whole thread Raw
In response to Re: getting the number of rows affected by a query  (Sam Mason <sam@samason.me.uk>)
Responses Re: getting the number of rows affected by a query  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Tree view 
On 16/11/2007 10:02, Sam Mason wrote:

>   SELECT COUNT(*) FROM (
>     DELETE FROM foo RETURNING 1) x;

I haven't played with this yet, but AFAICS this will simply return the
integer value "1".

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: Thomas Finneid
Date:
Subject: postgres 8 on solaris 9
Next
From: Sam Mason
Date:
Subject: Re: getting the number of rows affected by a query