"David Johnston" <polobo@yahoo.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