Re: [HACKERS] 7.3 -> pg_atoi: zero-length string

--On Tuesday, December 03, 2002 11:21:04 -0500 Bruce Momjian
<pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:

> 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.
He's at least the 2nd. I have one, that I've complained to the
PHPGroupware folks (which
BREAKS severely with this change).

LER

>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
> 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749