Subject: Re: Isnumeric function?
From: Oliver Elphick <olly@lfix.co.uk>
Reply-To: olly@lfix.co.uk
To: Josh Berkus <josh@agliodbs.com>
Cc: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>,
	pgsql-sql@postgresql.org
In-Reply-To: <200409080947.17682.josh@agliodbs.com>
References: <82E30406384FFB44AFD1012BAB230B55037D056E@shiva.au.lpint.net>
	<1094537126.6360.279.camel@linda>
	<200409080947.17682.josh@agliodbs.com>
Content-Type: text/plain
Organization: LFIX Limited
Message-Id: <1094664017.2014.80.camel@linda>
Mime-Version: 1.0
Date: Wed, 08 Sep 2004 18:20:17 +0100
Content-Transfer-Encoding: 7bit

On Wed, 2004-09-08 at 17:47, Josh Berkus wrote:
> Oliver, Theo:
> 
> >  ~ '^[0-9]+$'
> 
> Actually, I usually do:
> 
> ~ '^[0-9]+\.?[0-9]*$'
> 
> ... to include decimals.   However, the above assumes that there is at least a 
> "0" before the decimal; it would be nice to adapt it to matching a leading 
> decimal (i.e. .057 ) as well.   Can't see any easy way, though ...

 ~ '^([0-9]+|[0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+)$'

-- 
Oliver Elphick                                          olly@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
     "Put on the whole armor of God, that ye may be able to 
      stand against the wiles of the devil."        
                                        Ephesians 6:11