Re: getting the number of rows affected by a query

["Raymond O'Donnell" <rod@xxxxxx>]

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@xxxxxx
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend