Re: 7.3 -> pg_atoi: zero-length string

Ben-Nes Michael wrote:
> Then Why not set it to NULL

Well, it is not NULL, though, it is ''.  They are not the same in
strings (though for some dbms's they are), so I don't see why we would
do that for numerics.

> Seems logic as there is nothing between ''
>
> What is the solution of other dbs ( oracle, db2 .. ) to:
> insert into table (num) value (''); ?

I assume they would fail too.

> Who knows how many application will suffer becouse of this.

Yours is the first, or perhaps second to bring up this issue.
I am sure it is a pain, but it does tighten up some cases where we were
silently mapping '' to 0, and we don't exactly have a flood of problem
reports.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073