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(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:
> http://www.postgresql.org/mailpref/pgsql-sql