Re: Newbie question

On Thu, 26 Jun 2003, Vinay wrote:

> I have a very simple question regarding creating columns in a table
>
> Can we create a column in a table in such a way that it will allow only certain length, nothing less or nothing more
>
> here is an example
>
>
> create table test(column1 char(2));
>
> will create table with column1 which will accept characters upto length two.
> I want the column to accept the column value which is absolutely length of two.

create table p (name text check (length(name)=2));

I'm not sure I can make it work for char(), it seems, since char is always
autopadded out to two characters before it gets to the check constraint.

It will work with text and varchar(2) types.