partial index - Mailing list pgsql-general

From enediel
Subject partial index
Date
Msg-id 00c801c2eff2$e4338160$2824a8c0@nsoft
Whole thread Raw
List pgsql-general
the table of clients per intitutions looks like that

nu_institution
nu_client
client_name
....

I need a partial index of (upper(client_name)) per nu_institution

Reading the information about index declaration, I haven't found the way to
write the predicate to filter per nu_institution field name.

Thanks for help
Enediel
Linux user 300141

Happy who can penetrate the secret causes of the things
¡Use Linux!


pgsql-general by date:

Previous
From: Fernando Schapachnik
Date:
Subject: Re: Posts get losts
Next
From: Tom Lane
Date:
Subject: Re: 32/64-bit transaction IDs?