On 1/11/06, Marcos <mjs_ops(at)gmx(dot)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 ;)