constraints on composite types

Поиск
Список
Период
Сортировка
От Roman Neuhauser
Тема constraints on composite types
Дата
Msg-id 20050909123534.GB45736@isis.sigpipe.cz
обсуждение исходный текст
Ответы Re: constraints on composite types  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
This fails on 8.0.3 (syntax error at or near "." at character):

CREATE TYPE ct AS (
  foo INTEGER,
  bar INTEGER
);

CREATE TABLE t1 (
  attr ct,
  CONSTRAINT uq UNIQUE (attr.foo)
);

Should it be possible? From reading
http://www.postgresql.org/docs/current/static/rowtypes.html it looks
like almost everything else works.

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Is this a bug or am I doing something wrong?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Problem using NULLIF in a CASE expression