Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 842561A3BCAE for ; Wed, 29 Feb 2012 12:14:38 -0400 (AST) Received: from marvin.klingler.net ([91.212.121.244]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S2mAm-00071M-QR for pgsql-sql@postgresql.org; Wed, 29 Feb 2012 16:14:37 +0000 Received: from [10.0.60.1] (vpn.klingler.net [213.193.121.98]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by marvin.klingler.net (Postfix) with ESMTPSA id 63FAB33D2C for ; Wed, 29 Feb 2012 17:14:21 +0100 (CET) Date: Wed, 29 Feb 2012 17:14:21 +0100 From: Richard Klingler To: pgsql-sql@postgresql.org Message-ID: <20120229171421907526.563c7a4e@klingler.net> In-Reply-To: <1604.1330531726@sss.pgh.pa.us> References: <20111217113306531983.1eb85a86@klingler.net> <20120228133835204823.bbf29d1f@klingler.net> <1604.1330531726@sss.pgh.pa.us> Subject: Re: Natural sort order MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: GyazMail version 1.5.12 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/102 X-Sequence-Number: 36395 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 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