ADQL: MOD sign

Mark Taylor M.B.Taylor at bristol.ac.uk
Fri Aug 12 10:17:02 CEST 2016


On Thu, 11 Aug 2016, Walter Landry wrote:

> sqlite> select 7.2 % 3.5;
> 1.0

the posted examples haven't shown it yet, but at least some DBs
do this without integer coercion, e.g.:

mysql> select mod(7.2,3.5);
+--------------+
| mod(7.2,3.5) |
+--------------+
|          0.2 |
+--------------+

I think PostgreSQL too.

Get cosmopterix to test this?

--
Mark Taylor   Astronomical Programmer   Physics, Bristol University, UK
m.b.taylor at bris.ac.uk +44-117-9288776  http://www.star.bris.ac.uk/~mbt/


More information about the dal mailing list