Re: Validating Whole Numbers - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Validating Whole Numbers
Date
Msg-id E16i4ah-0003LM-00@maynard.mail.mindspring.net
Whole thread Raw
In response to Validating Whole Numbers  ("Krog, Kenneth" <KAKrog@MassMutual.com>)
List 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@turnstep.com
PGP Key: 0x14964AC8 200203042125

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

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



pgsql-general by date:

Previous
From: "PG"
Date:
Subject: Slow in VB Grid with PG
Next
From: "otisg"
Date:
Subject: Re: Help with SET TRANSACTION in a function