From: Bruno Wolff III <bruno@wolff.to>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: unique index on function and column
Date: Tue, 25 Jun 2002 15:34:53 -0500
Message-ID: <20020625203453.GA23747@wolff.to> (raw)
In-Reply-To: <200206251309.25232.josh@agliodbs.com>
References: <20020625175828.GA11107@wolff.to>
<200206251309.25232.josh@agliodbs.com>
On Tue, Jun 25, 2002 at 13:09:25 -0700,
Josh Berkus <josh@agliodbs.com> wrote:
> 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.
I was using it to implement a constraint, not to do searches. Two separate
indexes wouldn't work for that.
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: bruno@wolff.to, josh@agliodbs.com
Subject: Re: unique index on function and column
In-Reply-To: <20020625203453.GA23747@wolff.to>
* 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