From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-sql@postgresql.org
Subject: Re: unique index on function and column
Date: Tue, 25 Jun 2002 14:35:16 -0400
Message-ID: <9830.1025030116@sss.pgh.pa.us> (raw)
In-Reply-To: <20020625175828.GA11107@wolff.to>
References: <20020625175828.GA11107@wolff.to>
Bruno Wolff III <bruno@wolff.to> writes:
> 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.
The standard answer is to make a custom function that accepts all the
columns and produces a result you can index.
This is sort of an academic "an existence proof is good enough" answer,
but it *is* possible to get the results you want. Making it more
convenient hasn't risen to the top of anyone's to-do list.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, bruno@wolff.to
Subject: Re: unique index on function and column
In-Reply-To: <9830.1025030116@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox