Re: CHECK - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: CHECK
Date
Msg-id 327344.96515.qm@web31812.mail.mud.yahoo.com
Whole thread Raw
In response to CHECK  (scuffio <simone.dicola@gmail.com>)
List pgsql-general
--- 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.


pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Rule vs Trigger
Next
From: Tom Lane
Date:
Subject: Re: Error or bug?