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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Joel Rodrigues <borgempath(at)Phreaker(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: enforcing alphabetic/numeric content in "char" column
Date: 2002-11-07 17:01:03
Message-ID: 20021107170103.GB17449@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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]$')

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-11-07 18:02:45 Re: enforcing alphabetic/numeric content in "char" column
Previous Message Rod Kreisler 2002-11-07 15:14:03 Re: enforcing alphabetic/numeric content in "char" column