multiple fields index
От | enediel |
---|---|
Тема | multiple fields index |
Дата | |
Msg-id | 014901c2feba$c2943460$2824a8c0@nsoft обсуждение исходный текст |
Ответ на | Strange Error, with unique key (john.murdoch@ig.com.br) |
Ответы |
Re: multiple fields index
Re: multiple fields index |
Список | pgsql-general |
I need a database where all text information will be kept as the users wrote it. This purposes includes a problem to create unique indexes with multiples fields, where text fields are part of the indexes. Suppose for example a table INSTITUTIONS, and other table CLIENTS_PER_INSTITUTION I need to create a unique index (nu_intitution, client_name) in the second table where nu_intitution is an integer and a foreign key of the first table, and client_name is a text. Someting like create index i_clients on CLIENTS_PER_INSTITUTION (nu_intitution, upper(client_name)) is impossible, at least in the documentation I've read. It's just an example, but I have the similar case in many tables. Thanks in advance for any help to solve this problem Enediel Linux user 300141 Happy who can penetrate the secret causes of the things ¡Use Linux!
В списке pgsql-general по дате отправления: