Re: domains, types, constraints

Поиск
Список
Период
Сортировка
От Andrew Winkler
Тема Re: domains, types, constraints
Дата
Msg-id 874065.70950.qm@web52702.mail.re2.yahoo.com
обсуждение исходный текст
Ответ на domains, types, constraints  (Andrew Winkler <the_andrew_winkler@yahoo.com>)
Ответы Re: domains, types, constraints
Список pgsql-novice
Дерево обсуждения 

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 по дате отправления: