multiple fields index - Mailing list pgsql-general

From enediel
Subject multiple fields index
Date
Msg-id 014901c2feba$c2943460$2824a8c0@nsoft
Whole thread Raw
In response to Strange Error, with unique key  (john.murdoch@ig.com.br)
Responses Re: multiple fields index
Re: multiple fields index
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: aaagh... postgres is segfaulting? -- fix
Next
From: Joshua Moore-Oliva
Date:
Subject: Re: aaagh... postgres is segfaulting? -- fix