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