Is there a way to trap this error in plpgsql code?
I have a function that accepts integer and character varying. Inside
that function I need to cast that varchar to integer. Of course,
sometimes that is not possible.
When I run function like that, I get this errror:
fidel=# select * from
Hi, I believe you're looking for invalid_text_representation.
EXCEPTION WHEN invalid_text_representation THEN
regards
mk
2009/9/10 Mario Splivalo mario.spliv...@megafon.hr
Is there a way to trap this error in plpgsql code?
I have a function that accepts integer and character varying.
Marcin Krawczyk wrote:
Hi, I believe you're looking for invalid_text_representation.
EXCEPTION WHEN invalid_text_representation THEN
Thnx, that is it.
Mike
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription: