| From: | wsheldah(at)lexmark(dot)com |
|---|---|
| To: | Joel Rodrigues <borgempath(at)Phreaker(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: regular expression question |
| Date: | 2003-06-04 19:51:46 |
| Message-ID: | OF4CFFC0EE.F569601C-ON85256D3B.006D05F1@lexmark.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Did you try the obvious:
'^[0-9|, -]{0,10}$'
Wes Sheldahl
Joel Rodrigues <borgempath(at)Phreaker(dot)net>@postgresql.org on 06/04/2003
02:40:18 PM
Sent by: pgsql-general-owner(at)postgresql(dot)org
To: pgsql-general(at)postgresql(dot)org
cc:
Subject: [GENERAL] regular expression question
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2003-06-04 19:56:11 | Re: regular expression question |
| Previous Message | Jim C. Nasby | 2003-06-04 19:48:16 | Re: to copy a record |