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])

Reply via email to