Re: [BUGS] [SQL] Immutable function in index

#1

"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano (AT) mailbox (DOT) hu> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [SQL] Immutable function in index

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [SQL] Immutable function in index - 07-06-2004 , 08:52 AM