Re: [SQL] Immutable function in index - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [SQL] Immutable function in index
Date
Msg-id 28776.1089121079@sss.pgh.pa.us
Whole thread Raw
In response to Immutable function in index  ("SZŰCS Gábor" <surrano@mailbox.hu>)
List pgsql-bugs
"SZŰCS Gábor" <surrano@mailbox.hu> writes:
> tir=# CREATE INDEX ajanlat_cikk ON ajanlat (antinuller(cikk),
> antinuller(minoseg), tol);
> ERROR:  parser: parse error at or near "," at character 55

> I'm not sure what happened,

You're trying to use a 7.4 feature in 7.3.  Multiple functional columns
in one index is new in 7.4.
        regards, tom lane


pgsql-bugs by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: Immutable function in index
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1187: Problem in SQL Functions on Composite Types