Re: Validating Whole Numbers

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Validating Whole Numbers
Date: 2002-03-05 02:31:26
Message-ID: E16i4ah-0003LM-00@maynard.mail.mindspring.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200203042125

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

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

Browse pgsql-general by date

  From Date Subject
Next Message otisg 2002-03-05 03:05:37 Re: Help with SET TRANSACTION in a function
Previous Message PG 2002-03-05 01:22:46 Slow in VB Grid with PG