Re: domains, types, constraints

Can unique only reference columns? Am I not able to do what I'm trying to do here, or am I just being stupid
about how I'm trying to do it?

create type e_mail as (address text, domain text);
CREATE TYPE
create table e_mail_t ( e email, unique((e).address, (e).domain) );
ERROR: syntax error at or near "("
LINE 1: create table e_mail_t ( e email, unique((e).address, (e).dom...
^
create table e_mail_t ( e email, unique(e));
ERROR: data type email has no default operator class for access method "btree"
HINT: You must specify an operator class for the index or define a default operator class for the data type.
ERROR: syntax error at or near ")"
LINE 1: )

____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs