Re: regular expression question - Mailing list pgsql-general

From Joel Rodrigues
Subject Re: regular expression question
Date
Msg-id E13675F2-975C-11D7-BEC5-0005024EF27F@Phreaker.net
Whole thread Raw
In response to Re: regular expression question  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-general
On Thursday, June 5, 2003, at 01:14 , Jeff Eckermann wrote:

> '^[0-9, -]*$'


Thanks Jeff, Wes, Jim, Bruno ! And no, simply putting a space
wasn't really obvious to me :-)



> Try this:
>
> '^[[:digit:][:space:],-]{0,10}$'

Scott, thanks, that's more like what I had in mind, seems more
robust (idiot-proof).


> I don't think you can do what you want with a single regular
> expression.

Alvaro, you're right in that if I want to be exacting, rather
than simply keeping obviously undesirable data out, then I would
have to be more specific & elaborate.

Cheers & thank you ,
Joel



pgsql-general by date:

Previous
From: javier garcia - CEBAS
Date:
Subject: EXTERN JOIN with WHEN query
Next
From: Jon Earle
Date:
Subject: Re: Nulls get converted to 0 problem