Sorting strings numerically

From: Marek Šab (msab..uk.cvut.cz)
Date: Thu Sep 23 2010 - 10:35:51 UTC

Next message: gilbertoca: "Re: many to many relation"

Previous message: Andrus Adamchik: "Re: Child Contexts"
Next in thread: Michael Gentry: "Re: Sorting strings numerically"
Reply: Michael Gentry: "Re: Sorting strings numerically"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

I would like to know if there is a way to sort string(varchar) columns
numerically. I know it's bad design but legacy database can't be changed
atm. I'm talking about IPv4 columns, which we need to sort. ( In new
model I aim to store them as integers and map extra column in cayenne
with mysql INET_ATON(), hope it will work.)
I tried to add "+0" to sort order property, but it failed parsing.

Regards,

-- 
Marek Šabo

Next message: gilbertoca: "Re: many to many relation"
Previous message: Andrus Adamchik: "Re: Child Contexts"
Next in thread: Michael Gentry: "Re: Sorting strings numerically"
Reply: Michael Gentry: "Re: Sorting strings numerically"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Sep 23 2010 - 10:33:47 UTC