Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 709304764FA for ; Tue, 25 Jun 2002 14:10:13 -0400 (EDT) Mailbox-Line: From bruno@wolff.to Tue Jun 25 14:10:13 2002 Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (Postfix) with SMTP id 3169147655E for ; Tue, 25 Jun 2002 13:53:28 -0400 (EDT) Received: (qmail 11151 invoked by uid 500); 25 Jun 2002 17:58:28 -0000 Date: Tue, 25 Jun 2002 12:58:28 -0500 From: Bruno Wolff III To: pgsql-sql@postgresql.org Subject: unique index on function and column Message-ID: <20020625175828.GA11107@wolff.to> Mail-Followup-To: pgsql-sql@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.25i X-Spam-Status: No, hits=-1.9 required=5.0 tests=X_NOT_PRESENT version=2.30 X-Spam-Level: X-Archive-Number: 200206/335 X-Sequence-Number: 8300 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.