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

--On Tuesday, December 03, 2002 11:21:04 -0500 Bruce Momjian
<pgman@candle.pha.pa.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@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
>
> ---------------------------(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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749