"David Johnston" <polobo(at)yahoo(dot)com> wrote:
>> I think you could test for integer-ness by testing whether val % 0 =
0.
> Modulus is a division function anything "% 0" results in a
division-by-zero
It seems pretty clear that he meant "% 1".
test=# select '1.01'::numeric % 1;
?column?
----------
0.01
(1 row)
-Kevin