pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Aleatory exception
2+ messages / 1 participants
[nested] [flat]

* Aleatory exception
@ 2007-11-23 09:23  Sabin Coanda <sabin.coanda@deuromedia.ro>
  0 siblings, 1 reply; 2+ messages in thread

From: Sabin Coanda @ 2007-11-23 09:23 UTC (permalink / raw)
  To: pgsql-sql

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 





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Aleatory exception
@ 2007-11-23 09:26  Sabin Coanda <sabin.coanda@deuromedia.ro>
  parent: Sabin Coanda <sabin.coanda@deuromedia.ro>
  0 siblings, 0 replies; 2+ messages in thread

From: Sabin Coanda @ 2007-11-23 09:26 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2007-11-23 09:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-23 09:23 Aleatory exception Sabin Coanda <sabin.coanda@deuromedia.ro>
2007-11-23 09:26 ` Sabin Coanda <sabin.coanda@deuromedia.ro>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox