ilm...@ilmari.org (Dagfinn Ilmari Mannsåker) writes: > The behaviour seems to have changed in 9.6:
Indeed, https://www.postgresql.org/docs/current/static/release-9-6.html has the following entry: * Improve the accuracy of the ln(), log(), exp(), and pow() functions for type numeric (Dean Rasheed) > $ psql -p5495 > Line style is unicode. > Border style is 2. > psql (10.1, server 9.5.10) > Type "help" for help. > > ilmari@[local]:5495 ~=# select 0.12 ^ (-25); > ERROR: division by zero > ilmari@[local]:5495 ~=# \q > > $ psql -p5496 > Line style is unicode. > Border style is 2. > psql (10.1, server 9.6.6) > Type "help" for help. > > ilmari@[local]:5496 ~=# select 0.12 ^ (-25); > ┌───────────────────────────────────────────┐ > │ ?column? │ > ├───────────────────────────────────────────┤ > │ 104825960103961013959336.4983657883169110 │ > └───────────────────────────────────────────┘ > (1 row) > > ilmari@[local]:5496 ~=# \q > > - ilmari -- "A disappointingly low fraction of the human race is, at any given time, on fire." - Stig Sandbeck Mathisen
