Hi,
The following phenomenon was reported to pgsql-jp(ML in Japan).
rest=# select -1234567890.1234567;
ERROR: Unable to convert left operator '-' from type 'unknown'
-1234567890.1234567 is treated as - '1234567890.1234567'
as the following comment in scan.l says.
/* we no longer allow unary minus in numbers.* instead we pass it separately to parser. there it gets* coerced via
doNegate()-- Leon aug 20 1999*/
However doNegate() does nothing for SCONST('1234567890.1234567').
I don't understand where or how to combine '-' and numeric SCONST.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp