partial index

From: "enediel" <enediel(at)com(dot)ith(dot)tur(dot)cu>
To: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: partial index
Date: 2003-03-21 21:43:18
Message-ID: 00c801c2eff2$e4338160$2824a8c0@nsoft
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-21 21:51:13 Re: 32/64-bit transaction IDs?
Previous Message Ed L. 2003-03-21 21:38:12 Re: 32/64-bit transaction IDs?