Hi Henrikki,
On Mon, 2008-07-07 at 09:57 +0300, Henrikki Almusa wrote: > Syed Haider wrote: > > could you please elaborate why do you need the column as numbers ? > > 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. > > I guess it doesn't matter to mart if the column in database is integer > or decimal. yes - thats correct. cheers syed > -- ====================================== Syed Haider. EMBL-European Bioinformatics Institute Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. ======================================
