| From: | Marcos <mjs_ops(at)gmx(dot)net> |
|---|---|
| To: | Jaime Casanova <systemguards(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Create Produre for DROP row |
| Date: | 2006-01-20 13:38:32 |
| Message-ID: | 1137764312.1009.12.camel@servidor |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastjan Trepca | 2006-01-20 13:47:26 | Re: How to fetch rows with multiple values |
| Previous Message | Michael Glaesemann | 2006-01-20 13:30:29 | Re: How to fetch rows with multiple values |