Error handling inside PL/pgSQL functions

From: Germán Hüttemann Arza <ghuttemann(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error handling inside PL/pgSQL functions
Date: 2006-10-12 20:12:15
Message-ID: 598837360610121312m13d3aaa0xe0d221e0f3d388f9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am writing triggers procedures in PL/pgSQL and I need to handle some
errors inside the procedures.
Specifically, I am doing a CAST(char AS integer) and I want to know when the
char isn't a digit. How can I get do that?

Regards,

--
Germán Hüttemann

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-10-12 20:14:15 Re: List of supported 64bit OS
Previous Message Tom Lane 2006-10-12 19:50:40 Re: Question on MD5 authentication