Skip site navigation (1) Skip section navigation (2)

Re: Natural sort order

From: Richard Klingler <richard(at)klingler(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Natural sort order
Date: 2012-02-29 16:14:21
Message-ID: 20120229171421907526.563c7a4e@klingler.net (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

pgsql-sql by date

Next:From: Peter FaulksDate: 2012-02-29 19:50:39
Subject: date arithmetic with columns
Previous:From: Tom LaneDate: 2012-02-29 16:08:46
Subject: Re: Natural sort order

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group