Re: CHECK

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: scuffio <simone(dot)dicola(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: CHECK
Date: 2007-06-25 22:06:03
Message-ID: 327344.96515.qm@web31812.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


--- scuffio <simone(dot)dicola(at)gmail(dot)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.

In response to

  • CHECK at 2007-06-20 09:44:20 from scuffio

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-06-25 22:37:59 Re: Error or bug?
Previous Message Richard Broersma Jr 2007-06-25 22:00:16 Re: Rule vs Trigger