> 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,
Thanks.
When I use the EXCEPTION and I return a value numeric or text the
Postgresql shows a error of encoding :(... Invalid Encoding UTF-8 at...
This error only occurs when a EXCEPTION treated by me it's raised.
My database is in UTF8 encoding.
What's happen?
E.g:
EXCEPTION
WHEN others THEN RETURN 'Error';
Marcos.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend