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: | Raw Message | Whole Thread | 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 |