Richard Klingler <rich...@klingler.net> writes: > Took some time until I could try out this... > But as soon I want to create the fcuntion based index it tells me: > Error : ERROR: functions in index expression must be marked IMMUTABLE
FWIW, this example works fine for me. Maybe you have some weird user-defined version of substr() or ~ that isn't immutable? regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql