Home > mailing lists

Aleatory exception - Mailing list pgsql-sql

From	Sabin Coanda
Subject	Aleatory exception
Date	November 23, 2007 08:46:35
Msg-id	fi665u$tv9$1@news.hub.org Whole thread Raw
List	pgsql-sql

Tree view

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
forinteger: 
 
"NULL::int4"

For instance I got this for the following statement string:

Please explain what could be the reason ?

TIA,
Sabin

pgsql-sql by date:

From: Tom Lane
Date: 23 November 2007, 05:40:30
Subject: Re: PL argument max size, and doubt

From: "Sabin Coanda"
Date: 23 November 2007, 08:46:36
Subject: Re: Aleatory exception

Aleatory exception - Mailing list pgsql-sql

Previous

Next