--On Tuesday, December 03, 2002 11:21:04 -0500 Bruce Momjian <[EMAIL PROTECTED]> wrote:
He's at least the 2nd. I have one, that I've complained to the PHPGroupware folks (whichBen-Nes Michael wrote:Then Why not set it to NULLWell, 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.
BREAKS severely with this change).
LER
-- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
