Syed Haider wrote:
On Mon, 2008-07-07 at 09:57 +0300, Henrikki Almusa wrote:
Umm... I guess I need to test the more than thing. However in most cases
where sorting is done the result is different if the sort function
handles numbers as text instead of numbers. Eg unix commands 'sort'
(text based) and 'sort -n' (number based) orders 99 and 100 differently.
Just wondering if marking column as text and not number will cause these
kind of things.
The biomart-perl retrieves the data from mart just as it comes. Any
ORDER BY clause would considerably affect the query response time. If
you need a particualr order, its better to solve the problem at table
level rather software level.
Well I was thinking about the "ordering" needed to use '>' and '<'
qualifiers, sorry for being less than clear :). But I just tested it and
it's no problem.
I guess it doesn't matter to mart if the column in database is integer
or decimal.
yes - thats correct.
Thanks for helping out.
--
Henrikki Almusa
