| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il> |
| Cc: | Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, postgresql <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: 7.3 -> pg_atoi: zero-length string |
| Date: | 2002-12-03 16:21:04 |
| Message-ID: | 200212031621.gB3GL4k04233@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Kindness | 2002-12-03 16:28:24 | Re: 7.3 -> pg_atoi: zero-length string |
| Previous Message | Ben-Nes Michael | 2002-12-03 16:14:34 | Re: 7.3 -> pg_atoi: zero-length string |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Kindness | 2002-12-03 16:28:24 | Re: 7.3 -> pg_atoi: zero-length string |
| Previous Message | Fernando Nasser | 2002-12-03 16:20:22 | Re: ALTER TABLE schema SCHEMA TO new_schema? |