Natural sort order

From: Richard Klingler <richard(at)klingler(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Natural sort order
Date: 2011-12-17 10:33:06
Message-ID: 20111217113306531983.1eb85a86@klingler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stefan Weiss 2011-12-17 14:26:33 Re: Column "..." does not exist (view + union)
Previous Message Andreas Kretschmer 2011-12-17 09:02:46 Re: Column "..." does not exist (view + union)