From: Richard Klingler <richard@klingler.net>
To: pgsql-sql@postgresql.org
Subject: Natural sort order
Date: Sat, 17 Dec 2011 11:33:06 +0100
Message-ID: <20111217113306531983.1eb85a86@klingler.net> (raw)
Morning...
What is the fastest way to achieve natural ordering from queries?
I found a function at:
http://2kan.tumblr.com/post/361326656/postgres-natural-ordering
But it increases the query time from around 0.4msecs to 74msecs...
Might be not much if occasional queries are made..but I use it for
building
up a hierarchical tree menu in a web application where every msecs
counts (o;
cheers
richard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: richard@klingler.net
Subject: Re: Natural sort order
In-Reply-To: <20111217113306531983.1eb85a86@klingler.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox