"David Johnston" <pol...@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-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
