constraints on composite types - Mailing list pgsql-general

From Roman Neuhauser
Subject constraints on composite types
Date
Msg-id 20050909123534.GB45736@isis.sigpipe.cz
Whole thread Raw
Responses Re: constraints on composite types
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Is this a bug or am I doing something wrong?
Next
From: Richard Huxton
Date:
Subject: Re: Problem using NULLIF in a CASE expression