Natural sort

#31

DA Morgan <damorgan (AT) psoug (DOT) org> wrote:

Quote:

But, quite frankly, if what you are
asking is the case then the data should be stored in two separate
columns.

There might be at least one case where this is useful... filenames.

Right now I cavalierly present some lists of filenames from a
table in "non-natural" order, but I'm going to look into switching
to natural order with this trick.

--
Mark Harrison
Pixar Animation Studios

#32

DA Morgan <damorgan (AT) psoug (DOT) org> wrote:

Quote:

But, quite frankly, if what you are
asking is the case then the data should be stored in two separate
columns.

There might be at least one case where this is useful... filenames.

Right now I cavalierly present some lists of filenames from a
table in "non-natural" order, but I'm going to look into switching
to natural order with this trick.

--
Mark Harrison
Pixar Animation Studios

#33

DA Morgan <damorgan (AT) psoug (DOT) org> wrote:

Quote:

But, quite frankly, if what you are
asking is the case then the data should be stored in two separate
columns.

There might be at least one case where this is useful... filenames.

Right now I cavalierly present some lists of filenames from a
table in "non-natural" order, but I'm going to look into switching
to natural order with this trick.

--
Mark Harrison
Pixar Animation Studios

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Natural sort

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Natural sort - 10-20-2008 , 06:25 PM

Re: Natural sort - 10-20-2008 , 06:25 PM

Re: Natural sort - 10-20-2008 , 06:25 PM