| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | "pgsql-hackers" <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Numeric with '-' |
| Date: | 2000-02-22 04:53:09 |
| Message-ID: | 22275.951195189@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
>> They didn't give any such warning before, either. I doubt I've
>> made anything worse.
> Before your change
> INSERT into t (numdata) values (-1234567890.1234567);
> caused an error
> ERROR: Unable to convert left operator '-' from type 'unknown'.
> but currently inserts a constant -1234567890.12346.
Yipes, you are right. I think that that sort of construct should
result in the value not getting converted at all until the parser
knows that it must be converted to the destination column's type.
Let me see if I can find out what's going wrong. If this doesn't
seem to be fixable, I may have to back off the patch...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Baccus | 2000-02-22 05:05:51 | Re: [HACKERS] Re: [PATCHES] Patch for more readable parse error messages |
| Previous Message | Tatsuo Ishii | 2000-02-22 04:45:39 | Re: [HACKERS] Beta for 4:30AST ... ? |