Re: Validating Whole Numbers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> WHERE x ~ '^[0-9]*$'

You might want to change that asterick to a plus:

WHERE x ~ '^[0-9]+$'

so you don't get a false negative for an empty string.


Greg Sabino Mullane  greg@turnstep.com
PGP Key: 0x14964AC8 200203042125

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE8hC3FvJuQZxSWSsgRAmxnAJ9f/63H8JYnDjYc5VeVpOyrNxQm0ACaAjOY
3rmFQpTMVK+SrXJx7kOt9S0=
=PTUa
-----END PGP SIGNATURE-----