Re: Index on computed column - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Index on computed column
Date
Msg-id 20040426110455.T9774@megazone.bigpanda.com
Whole thread Raw
In response to Index on computed column  (han.holl@pobox.com (Han Holl))
List pgsql-general
On Tue, 20 Apr 2004, Han Holl wrote:

> Hi,
>
> 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:
>
> palga=> select rubriek(rapport, lseek, 'naamvrouw',0) from main
>      where rapport = 'T098-20900';
>   rubriek
> -----------
>  Ramrattan
> (1 row)
> palga=> create index nm_idx on main (rubriek(rapport, lseek, 'naamvrouw',0));
> ERROR:  parser: parse error at or near "'naamvrouw'" at character 54
> palga=>
>
> This is postgresql-7.3.4-3.rhl9.

In 7.3, functional indexes can only be across columns of the table, so
something like the above is illegal.  You can get around this my making a
function that hardcodes the constants and then use that in the index and
queries.

In 7.4, you can index a more general set of expressions.

pgsql-general by date:

Previous
From: Guy Fraser
Date:
Subject: Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly
Next
From: Andrew Ayers
Date:
Subject: Re: Installation Postgresql