Re: constraints on composite types

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Richard Huxton <dev@xxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match