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

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 ?


----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Larry Rosenman" <ler@lerctr.org>
Cc: "Ben-Nes Michael" <miki@canaan.co.il>; "Lee Kindness"
<lkindness@csl.co.uk>; "postgresql" <pgsql-general@postgresql.org>;
<pgsql-hackers@postgresql.org>
Sent: Tuesday, December 03, 2002 7:12 PM
Subject: Re: [HACKERS] [GENERAL] 7.3 -> pg_atoi: zero-length string


>
> If we had received more complaints about the change during beta, we
> would have added a mention that the change would be in 7.4.  As we got
> few complaints, the change went into 7.3, and it is mentioned in the
> porting section of the release notes (last item):
>
>      * An empty string ('') is no longer allowed as the input into an
>        integer field. Formerly, it was silently interpreted as 0.
>
> --------------------------------------------------------------------------
-
>
> Larry Rosenman wrote:
> >
> >
> > --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
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> --
>   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
>