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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
