Re: [GENERAL] Error handling inside PL/pgSQL functions

2006-10-12 Thread Jeff Davis
On Thu, 2006-10-12 at 16:12 -0400, Germán Hüttemann Arza wrote: > 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? > >

Re: [GENERAL] Error handling inside PL/pgSQL functions

2006-10-12 Thread Jeff Davis
On Thu, 2006-10-12 at 15:22 -0500, Tony Caduto wrote: > Germán Hüttemann Arza wrote: > > 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

Re: [GENERAL] Error handling inside PL/pgSQL functions

2006-10-12 Thread Tony Caduto
Germán Hüttemann Arza wrote: 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? Just off the top of my head I would say you