Re: enforcing alphabetic/numeric content in "char" column - Mailing list pgsql-novice

From Joel Rodrigues
Subject Re: enforcing alphabetic/numeric content in "char" column
Date
Msg-id 16BA6F5E-F313-11D6-BAA5-0005024EF27F@Phreaker.net
Whole thread Raw
In response to Re: enforcing alphabetic/numeric content in "char" column  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: enforcing alphabetic/numeric content in "char" column  (Rod Kreisler <rod@23net.net>)
List 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@Phreaker.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



pgsql-novice by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: Performance
Next
From: Rod Kreisler
Date:
Subject: Re: enforcing alphabetic/numeric content in "char" column