Natural sort order - Mailing list pgsql-sql

From Richard Klingler
Subject Natural sort order
Date
Msg-id 20111217113306531983.1eb85a86@klingler.net
Whole thread Raw
Responses Re: Natural sort order
Re: Natural sort order
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Column "..." does not exist (view + union)
Next
From: Stefan Weiss
Date:
Subject: Re: Column "..." does not exist (view + union)