Re: Domains (was Re: int1?)
От | Ron Johnson |
---|---|
Тема | Re: Domains (was Re: int1?) |
Дата | |
Msg-id | 1065728768.1233.88.camel@haggis обсуждение исходный текст |
Ответ на | Re: Domains (was Re: int1?) (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: Domains (was Re: int1?)
|
Список | pgsql-general |
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.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. So is there a documentation "bug", or, what kind of constraints can be placed on domains besides { NOT NULL | NULL }? -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA Causation does NOT equal correlation !!!!!!!!
В списке pgsql-general по дате отправления: