Re: Natural sort order - Mailing list pgsql-sql

From Tom Lane
Subject Re: Natural sort order
Date
Msg-id 1604.1330531726@sss.pgh.pa.us
Whole thread Raw
In response to Re: Natural sort order  (Richard Klingler <richard@klingler.net>)
Responses Re: Natural sort order  (Richard Klingler <richard@klingler.net>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Marcin Krawczyk
Date:
Subject: Re: custom_variable_classes in 9.1
Next
From: Richard Klingler
Date:
Subject: Re: Natural sort order