Skip site navigation (1) Skip section navigation (2)

Re: How I can check a substring is a valid number in postgresql ?

From: TJ O'Donnell <tjo(at)acm(dot)org>
To: anoopmadavoor(at)gmail(dot)com, PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How I can check a substring is a valid number in postgresql ?
Date: 2008-04-24 15:43:17
Message-ID: 4810AA95.3080609@acm.org (view raw or flat)
Thread:
Lists: pgsql-sql
This regular expression works for numeric/float values as
well as integers.  It allows for exponents.

tvalue ~ E'^[+-]?[0-9]+(\\\\.[0-9]*)?([Ee][+-]?[0-9]+)?\$'

TJ O'Donnell
http://www.gnova.com/

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-04-24 15:44:44
Subject: Re: First day of month, last day of month
Previous:From: Scott MarloweDate: 2008-04-24 15:16:01
Subject: Re: First day of month, last day of month

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group