Postgres Pro
Downloads
Home   >   mailing lists

Re: How I can check a substring is a valid number in postgresql ? - Mailing list pgsql-sql

From TJ O'Donnell
Subject Re: How I can check a substring is a valid number in postgresql ?
Date
Msg-id 4810AA95.3080609@acm.org
Whole thread Raw
In response to How I can check a substring is a valid number in postgresql ?  ("Anoop G" <anoopmadavoor@gmail.com>)
List pgsql-sql
Tree view 
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:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: First day of month, last day of month
Next
From: "Scott Marlowe"
Date:
Subject: Re: First day of month, last day of month