Group: pgsql.sql


Subject: Aleatory exception
From: Sabin Coanda
Date: 11/23/2007 11:23:15 AM
Hi there, I have a custom function where I execute a dynamic statement. I trap the exceptions, and sometimes I got the following error data: SQLSTATE = 22P02, SQLERRM = invalid input syntax for integer: "NULL::int4" For instance I got this for the following statement string: Please explain what could be the reason ? TIA, Sabin

Subject: Aleatory exception
From: Sabin Coanda
Date: 11/23/2007 11:26:51 AM
Sorry for the previous incomplete text. I add the followings: For instance I got that exception for the following statement string: '"my_function"( NULL, ''TEXT1'', NULL::int4, NULL::int4, 5413, '''', TIMESTAMP WITH TIME ZONE ''2007-11-23 10:08:29.904+02'', 19255, 0 )' What is wrong with this statement ? Regards, Sabin