Re: Index on computed column

On Tue, 20 Apr 2004, Han Holl wrote:

> 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.
> 

You cannot create functional indexes with a constant in the 7.3 series.  
This capability was only added in the 7.4 series.  You can work around 
this problem by creating a wrapper function that calls the real function 
with the constants and creating the index on the wrapper function.

Kris Jurka