Hi,
Finally I found the cause of the problem.
I found deeper inside my calls, a function which has to return an integer
column from a RECORD rec variable. The rec is assigned with the following
statement:
EXECUTE 'SELECT pk AS "PK" FROM "my_table" WHERE my_where_clause'
INTO rec.
When
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
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