Edoardo Ceccarelli <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])