Edoardo Ceccarelli <eddy@axa.it> writes:
> I wasn't able to make this 2 field index with lower:
> dba400=# CREATE INDEX annuncio400_rubric_testo_idx ON
> annuncio400(rubric, LOWER(testo));
> ERROR: parser: parse error at or near "(" at character 71
> seems impossible to creat 2 field indexes with lower function.
You need 7.4 to do that; previous releases don't support multi-column
functional indexes.
regards, tom lane