Re: Isnumeric function?
От | Oliver Elphick |
---|---|
Тема | Re: Isnumeric function? |
Дата | |
Msg-id | 1094664017.2014.80.camel@linda обсуждение исходный текст |
Ответ на | Re: Isnumeric function? (Josh Berkus <josh@agliodbs.com>) |
Ответы |
Re: Isnumeric function?
|
Список | pgsql-sql |
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 thewiles of the devil." Ephesians 6:11
В списке pgsql-sql по дате отправления: