On Thu, Oct 09, 2003 at 14:28:57 -0500,
Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
>
> http://www.postgresql.org/docs/7.3/static/sql-createdomain.html
> CREATE DOMAIN domainname [AS] data_type
> [ DEFAULT default_expr ]
> [ constraint [, ... ] ]
>
> where constraint is:
>
> [ CONSTRAINT constraint_name ]
> { NOT NULL | NULL }
>
> test1=# create domain d_tinyint as smallint constraint chk_tinyint CHECK (smallint between 0 and 255);
> ERROR: DefineDomain: CHECK Constraints not supported
>
> So, how would I create a domain that limits a smallint?
You need to use 7.4. In 7.3 you couldn't use check constraints with domains.