Re: Domains (was Re: int1?) - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Domains (was Re: int1?)
Date
Msg-id 20031009194633.GA14861@wolff.to
Whole thread Raw
In response to Domains (was Re: int1?)  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Domains (was Re: int1?)
List pgsql-general
On Thu, Oct 09, 2003 at 14:28:57 -0500,
  Ron Johnson <ron.l.johnson@cox.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.

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Response from MySql AB (Re: Humor me: Postgresql vs.
Next
From: "Ian Harding"
Date:
Subject: Re: autoupdate sequences after copy