Re: getting the number of rows affected by a query

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