regular expression question - Mailing list pgsql-general

<fixed><fontfamily><param>Andale Mono</param>Hi,

I'm trying to write a check on a column restricting the data to
numerals from 0-9, commas,  dashes '-' and single spaces. To allow the
entry of something like "134-140, 310-312".


I seem to have got everything but the single spaces.


'^[0-9|,-]{0,10}$'



Hope you can help !


Cheers,

Joel</fontfamily></fixed>
Hi,
I'm trying to write a check on a column restricting the data to
numerals from 0-9, commas,  dashes '-' and single spaces. To
allow the entry of something like "134-140, 310-312".

I seem to have got everything but the single spaces.

'^[0-9|,-]{0,10}$'


Hope you can help !

Cheers,
Joel

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Nulls get converted to 0 problem
Next
From: Bruno Wolff III
Date:
Subject: Re: regular expression question