Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: enforcing alphabetic/numeric content in "char" column
Date
Msg-id 20021107170103.GB17449@wolff.to
Whole thread Raw
In response to enforcing alphabetic/numeric content in "char" column  (Joel Rodrigues <borgempath@Phreaker.net>)
Responses Re: enforcing alphabetic/numeric content in "char" column
List pgsql-novice
Tree view 
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]$')

pgsql-novice by date:

Previous
From: Rod Kreisler
Date:
Subject: Re: enforcing alphabetic/numeric content in "char" column
Next
From: Tom Lane
Date:
Subject: Re: enforcing alphabetic/numeric content in "char" column