From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: unique index on function and column |
Date: | 2002-06-25 18:45:58 |
Message-ID: | 20020625184558.GA11367@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Tue, Jun 25, 2002 at 14:35:16 -0400,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bruno Wolff III <bruno(at)wolff(dot)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.
It probably isn't worth the trouble in this case. The number of rows is small
and I will use a unique index without forcing a case independpent comparison.
For the time being this is good enough.
Thanks for confirming that I was reading the manually correctly.
From | Date | Subject | |
---|---|---|---|
Next Message | Eric | 2002-06-25 19:25:32 | 2 Selects 1 is faster, why? |
Previous Message | Tom Lane | 2002-06-25 18:35:16 | Re: unique index on function and column |