Actually got it figured...for some reason it had the function twice (o; But with or without function index the time to query stays the same...around 110msec for 24 results...
cheers richard On Wed, 29 Feb 2012 11:08:46 -0500, Tom Lane wrote: > 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
