Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject unique index on function and column
Date
Msg-id 20020625175828.GA11107@wolff.to
Whole thread Raw
Responses Re: unique index on function and column  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: unique index on function and column  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: alla@sergey.com (Alla)
Date:
Subject: Re: rowtype and ecpg
Next
From: Tom Lane
Date:
Subject: Re: unique index on function and column