Postgres Pro
Downloads
Home   >   mailing lists

Error handling inside PL/pgSQL functions - Mailing list pgsql-general

From Germán Hüttemann Arza
Subject Error handling inside PL/pgSQL functions
Date
Msg-id 598837360610121312m13d3aaa0xe0d221e0f3d388f9@mail.gmail.com
Whole thread Raw
Responses Re: Error handling inside PL/pgSQL functions  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Re: Error handling inside PL/pgSQL functions  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question on MD5 authentication
Next
From: "Joshua D. Drake"
Date:
Subject: Re: List of supported 64bit OS