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