Re: Create Produre for DROP row

On 1/11/06, Marcos <mjs_ops@gmx.net> wrote:
> Hi,
>
> Does have possible create one procedure to delete a row that return TRUE
> if the deletion was success or FALSE if a error occur?
>
> The procedure for deletion I already create but I don't know how detect
> if the deletion was success executed.
>
> Languagel: plpgsql
>
> Thanks.
>

in 8.x.x

BEGIN

     DELETE FROM .....

EXCEPTION
       WHEN others THEN
                  ...........
END;

documentation:
http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

a list of errors:
http://www.postgresql.org/docs/current/static/errcodes-appendix.html

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)