Re: enforcing alphabetic/numeric content in "char" column

From: Joel Rodrigues <borgempath(at)Phreaker(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: enforcing alphabetic/numeric content in "char" column
Date: 2002-11-08 12:10:36
Message-ID: 16BA6F5E-F313-11D6-BAA5-0005024EF27F@Phreaker.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thursday, November 7, 2002, at 10:31 , Bruno Wolff III wrote:

> On Thu, Nov 07, 2002 at 19:37:23 +0530,
> Joel Rodrigues <borgempath(at)Phreaker(dot)net> wrote:
>>
>> iso3dnum char(3) CHECK (iso3dnum ~ '[0-9]')
>
> iso3dnum char(3) CHECK (iso3dnum ~ '^[0-9][0-9][0-9]$')
>

Thank you Bruno & Rod ! This one works. So it's one [0-9] for
every character.

Obrigado !
Joel

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rod Kreisler 2002-11-08 12:39:30 Re: enforcing alphabetic/numeric content in "char" column
Previous Message Andrew McMillan 2002-11-08 10:08:00 Re: Performance