Re: 7.3 -> pg_atoi: zero-length string

Same as in the INSERT case:

 iidbdb=# SELECT version();
                           version
 -----------------------------------------------------------
  PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96
 (1 row)

 iidbdb=# SELECT int4('');
 ERROR:  pg_atoi: zero-length string
 iidbdb=# SELECT CAST('' AS int4);
 ERROR:  pg_atoi: zero-length string

Lee.

SZUCS Gábor writes:
 > I don't have 7.3 installed, just wondering...
 >
 > What do the following do in PostgreSQL 7.3?
 >
 > SELECT int4('');
 > SELECT CAST('' AS int4);
 >
 > G.
 > --
 > while (!asleep()) sheep++;
 >
 > ---------------------------- cut here ------------------------------
 > ----- Original Message -----
 > From: "Ben-Nes Michael" <miki@canaan.co.il>
 > Sent: Tuesday, December 03, 2002 6:17 PM
 >
 >
 > > Well I already fixed all my application, it was quiet easy though more
 > code
 > > was entered :(
 > >
 > > like:
 > >
 > > if ( !is_numeric($var) )
 > >     $var = 0;
 > >
 > > I hope the other projects will fix compliance fast.
 > >
 > > maybe this feature should be enabled when compiling ?