Salut,
Cum as putea fixa chestia asta, in afara de refacerea tabelei cu tipuri
NUMERIC ?
adming2003-vara=# SELECT nrleg, (med9 + med10 + med11 + med12)/4. FROM
medii_ani WHERE nrleg = 'P028';
nrleg | ?column?
-------+------------------
P028 | 8.80999946594238
(1 row)
aici trebuie sa dea 8.81000000 (in cap).
mysql da mai precis:
mysql> SELECT (med9 + med10 + med11 + med12)/4 FROM mumu;
+----------------------------------+
| (med9 + med10 + med11 + med12)/4 |
+----------------------------------+
| 8.8100000619888 |
+----------------------------------+
1 row in set (0.06 sec)
adming2003-vara=# SELECT * FROM medii_ani where nrleg = 'P028';
nrleg | med9 | med10 | med11 | med12
-------+------+-------+-------+-------
P028 | 7.77 | 8.78 | 9.17 | 9.52
(1 row)
De asemenea, am vazut tampenii si in php la functiile floor, sprintf ("%
A.Bf), etc...
Dar nici una nu am gasit sa dea absolut exact...
--
Claudiu Cismaru
GPG Key: http://maya.cnixs.com/~claudiu/claudiu.gpg
