Postgres Pro
Downloads
Home   >   mailing lists

Thread: CHECK

CHECK

From
scuffio
Date:
I would want to know as I make to control that the length of the field
character insert is of one sure dimension

Re: CHECK

From
Richard Broersma Jr
Date:
--- scuffio <simone.dicola@gmail.com> wrote:

> I would want to know as I make to control that the length of the field
> character insert is of one sure dimension

A check constraint can certainly do this.  If you want to generalize it, you can roll you check
constraint into a domain (user defined column type).
http://www.postgresql.org/docs/8.2/interactive/ddl-constraints.html
http://www.postgresql.org/docs/8.2/interactive/sql-createdomain.html

Regards,
Richard Broersma Jr.