> 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