Re: [GENERAL] Delete function

2004-12-06 Thread Richard Huxton
Secrétariat wrote: Hello ! I create a delete function : CREATE FUNCTION delalpha(varchar, integer) RETURNS boolean AS 'DELETE FROM public.params WHERE soc = $1 AND numpar = $2 ; SELECT TRUE ;' LANGUAGE sql ; Is there a way to return the number of deleted row ? Thanks. If you rewr

[GENERAL] Delete function

2004-12-06 Thread Secrétariat
Hello !   I create a delete function : CREATE FUNCTION delalpha(varchar, integer) RETURNS boolean    AS 'DELETE FROM public.params WHERE soc = $1 AND numpar = $2 ;  SELECT  TRUE ;'    LANGUAGE sql ;Is there a way to return the number of deleted row ? Thanks.   Luc