Re: unique index on function and column - Mailing list pgsql-sql

From Josh Berkus
Subject Re: unique index on function and column
Date
Msg-id 200206251309.25232.josh@agliodbs.com
Whole thread Raw
In response to unique index on function and column  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: unique index on function and column  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
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





pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: unique index on function and column
Next
From: Bruno Wolff III
Date:
Subject: Re: unique index on function and column