Re: domains, types, constraints
От
Andrew Winkler
Тема
Re: domains, types, constraints
Дата
Msg-id
874065.70950.qm@web52702.mail.re2.yahoo.com
Список
Дерево обсуждения
Re: domains, types, constraints Andrew Winkler <the_andrew_winkler@yahoo.com>
Re: domains, types, constraints Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-novice по дате отправления
