unique index on function and column

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-sql(at)postgresql(dot)org
Subject: unique index on function and column
Date: 2002-06-25 17:58:28
Message-ID: 20020625175828.GA11107@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-06-25 18:35:16 Re: unique index on function and column
Previous Message tdn 2002-06-25 06:44:05 altering column width