Re: [SQL] Trapping 'invalid input syntax for integer'

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: http://www.postgresql

Re: [SQL] Trapping 'invalid input syntax for integer'

Hi, I believe you're looking for invalid_text_representation. EXCEPTION WHEN invalid_text_representation THEN regards mk 2009/9/10 Mario Splivalo > 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 nee

[SQL] Trapping 'invalid input syntax for integer'

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 get_acco