View Single Post

   
  #6 (permalink)  
Old 04-09-2008, 11:10 PM
Raymond O'Donnell
 
Posts: n/a
Default 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
---------------------------------------------------------------

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

Reply With Quote