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 <richard@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