MySQL
mysql> select cast(85 as decimal(3,2)); +--------------------------+ | cast(85 as decimal(3,2)) | +--------------------------+ | 9.99 | +--------------------------+ 1 row in set, 1 warning (0.00 sec)
PostgreSQL
template1=# select cast(85 as decimal(3,2)); LOG: statement: select cast(85 as decimal(3,2)); ERROR: numeric field overflow DETAIL: The absolute value is greater than or equal to 10^1 for field with precision 3, scale 2.
O Mysql sempre silenciando os erros... ![]()
Subscribe: 



