"David Johnston" <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
