Re: Domains (was Re: int1?)

On Thu, 2003-10-09 at 14:46, Bruno Wolff III wrote:
> 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.

So is there a documentation "bug", or, what kind of constraints
can be placed on domains besides { NOT NULL | NULL }?

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA

Causation does NOT equal correlation !!!!!!!!