Re: What query can sort this?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Fri, 5 Sep 2003 13:20:37 -0700
Message-ID: <Nm66b.27$pP2.95@news.oracle.com>

"Sean" <aether8203_at_yahoo.com> wrote in message news:9f0ea455.0309031737.5028d39a_at_posting.google.com...
> I have been trying to sort on a column of data and am stumped. Does
> anyone have any advice?
>
> The column is a VARCHAR2(15)
>
> Footnote_no
> ------------
> 1
> 1.1
> 1.2
> 1.2.1
> 1.2.2
> 1.2.2.1
> 1.4
> 1.6
> 1.10
> 1.11
> 1.12
> 1.12.1
> 1.12.1.1

You can convert materialized path into nested intervals, which can naturally be sorted. The method (with all operators already implemented) is here: http://www.dbazine.com/tropashko4.html Received on Fri Sep 05 2003 - 15:20:37 CDT