Re: [GENERAL] getting the number of rows affected by a query

[Raymond O'Donnell]

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
[EMAIL PROTECTED]
---------------------------------------------------------------

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