Re: regular expression question

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

Browse pgsql-general by date

  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