Re: constraints on composite types - Mailing list pgsql-general

Richard Huxton <dev@archonet.com> writes:
> Tom Lane wrote:
>> I don't believe you need the function -- this should be enough:
>>
>> CREATE UNIQUE INDEX t1_b_uniq ON t1 ((attr.foo));

> I got: Relation "attr" does not exist (on 8.1 beta)

Sorry, make that

CREATE UNIQUE INDEX t1_b_uniq ON t1 (((attr).foo));

            regards, tom lane