Re: doubts about a constraint's definition
От | enediel |
---|---|
Тема | Re: doubts about a constraint's definition |
Дата | |
Msg-id | 008a01c2efd0$cb1285e0$2824a8c0@nsoft обсуждение исходный текст |
Ответ на | doubts about a constraint's definition ("enediel" <enediel@com.ith.tur.cu>) |
Список | pgsql-general |
Thanks Peter for your attention, it's exactly what I needed :>) Greetings Enediel Linux user 300141 Happy who can penetrate the secret causes of the things ¡Use Linux! ----- Original Message ----- From: "Peter Gibbs" <peter@emkel.co.za> To: "enediel" <enediel@com.ith.tur.cu>; "postgresql" <pgsql-general@postgresql.org> Sent: Friday, March 21, 2003 6:32 AM Subject: Re: [GENERAL] doubts about a constraint's definition > enediel wrote: > > > I need to create a column, where the information is conserved in the same > > way that it was written by the user, but the data of this column is unique > > if it's only taken to capital > > > > declaring a constraint > > ... unique(column name) is not enough to me 'cause > > > > 'ab' > > 'AB' > > 'aB' > > .... > > will be accepted > > > > Create a unique functional index e.g. > create unique index index_name on table_name (upper(fieldname)); > -- > Peter Gibbs > EmKel Systems > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >
В списке pgsql-general по дате отправления: