On 17 May 2018, at 23:13, Keith Medcalf wrote:
> select col1, col2 from mytable order by cast(body_size as float);
Thank you. That's much better (although abs(body_size) worked too).
--
Cheers -- Tim
___
sqlite-users mailing
> select col1, col2 from mytable order by cast(body_size as float);
And if you care about speed of select, you could create appropriate index:
create index mytable_bodysize_index on mytable(cast(body_size as float));
2018-05-18 0:13 GMT+02:00, Keith Medcalf :
>
> Why not
Why not encode (speak / say) what you want to do directly, rather than
prayerfully relying on implementation details --
select col1, col2 from mytable order by cast(body_size as float);
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated
My db has a table with a column defined thus:
body_size text default '0.0'
whose purpose is to hold the size of the item that the row represents. All rows
contain a value but as a string to one decimal place, not a number. So the
column contains strings such as '0.0', '3.7', '22.9', etc. All
4 matches
Mail list logo