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...
On Wed, 29 Feb 2012 11:08:46 -0500, Tom Lane wrote:
> Richard Klingler <richard(at)klingler(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-sql by date
|Next:||From: Peter Faulks||Date: 2012-02-29 19:50:39|
|Subject: date arithmetic with columns|
|Previous:||From: Tom Lane||Date: 2012-02-29 16:08:46|
|Subject: Re: Natural sort order |