Re: Natural sort order

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