On Tue, Jun 25, 2002 at 13:09:25 -0700, Josh Berkus <josh@agliodbs.com> wrote:
> 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.
I was using it to implement a constraint, not to do searches. Two separate
indexes wouldn't work for that.