Re: Index on computed column

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Han Holl <han(dot)holl(at)pobox(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index on computed column
Date: 2004-04-26 18:23:28
Message-ID: 20040426182328.GB1580@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 20, 2004 at 12:48:42PM -0700, Han Holl wrote:

> Can anyone explain to me what I'm doing wrong:
> (The first select is to show that the function rubriek exists, and does work).
> I want to create an index on a computed column:

Functional indexes could not have constants in 7.3; you can build a
wrapper function with the constant embedded, and create an index using
the wrapper function.

Or you can just use 7.4.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La virtud es el justo medio entre dos defectos" (Aristóteles)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2004-04-26 18:23:36 Re: Replication
Previous Message Chadwick Boggs 2004-04-26 18:12:12 Re: Arbitrary precision modulo operation