On Thu, 2003-10-09 at 15:13, Bruno Wolff III wrote: > On Thu, Oct 09, 2003 at 14:46:08 -0500, > Ron Johnson <[EMAIL PROTECTED]> wrote: > > On Thu, 2003-10-09 at 14:46, Bruno Wolff III wrote: > > > On Thu, Oct 09, 2003 at 14:28:57 -0500, > > > Ron Johnson <[EMAIL PROTECTED]> 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 }? > > I think the documentation is correct. As I read it it says that only NOT NULL > and NULL constraints are allowed. This is easy to overlook. I know I got > caught by this when I tried it.
test1=# create domain foo as smallint not null; CREATE DOMAIN test1=# create domain bar as smallint CONSTRAINT wiggle not null; CREATE DOMAIN Oh, ok. Stuff in [] is not necessary. Still confusing. -- ----------------------------------------------------------------- Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA The difference between drunken sailors and Congressmen is that drunken sailors spend their own money. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster