Hi!
>>>>> "Roland" == Roland <roland@stripped> writes:
<cut>
Roland> FEATURE REQUEST:
Roland> Allow an alternate syntax for double types. When the exponent is positive
Roland> the plus sign may be omitted. That means
Roland> 3.41E+7 == 3.41E7.
Roland> Would that be too hard to implement? I don't think so. But it would save
Roland> other programmers a lot of work. The way it is now,
Roland> each application programmer has to program his own conversion, or use the
Roland> single-quotes trick.
Just tested this in MySQL 4.0:
mysql> select 3.41E+7,3.41E7,3.41E+7=3.41E7;
+----------+----------+----------------+
| 3.41E+7 | 3.41E7 | 3.41E+7=3.41E7 |
+----------+----------+----------------+
| 34100000 | 34100000 | 1 |
+----------+----------+----------------+
1 row in set (0.00 sec)
Regards,
Monty