Bruno,
> Is there a simple way to do something like the following:
> create unique index inst_u_app on inst (lower(host), psport);
>
> It looks like you can have an index on several columns, but not
> several functions.
So? Create two seperate indexes.
Multi-column indexes are almost always less useful that you'd expected,
anyway.
--
-Josh Berkus