Re: [sqlite] Ordering looks incorrect

2016-09-15 Thread David Crayford
On 14/09/2016 9:59 PM, R Smith wrote: I think this is answered, but since you are a bit new to SQLite, and to be somewhat more informant... SQLite is certainly a different experience to the enterprise class data bases that I'm used to but I like it. I'm still getting used to the duck

Re: [sqlite] Ordering looks incorrect

2016-09-14 Thread R Smith
I think this is answered, but since you are a bit new to SQLite, and to be somewhat more informant... On 2016/09/14 3:19 PM, David Crayford wrote: Of course. How do I do something similar to DB2 decimal() function which will add trailing zeros to precision? I tried round(col,6) but it knocked

Re: [sqlite] Ordering looks incorrect

2016-09-14 Thread David Crayford
On 14/09/2016 9:23 PM, Clemens Ladisch wrote: David Crayford wrote: How do I do something similar to DB2 decimal() function which will add trailing zeros to precision? You could use the standard SQL CAST() to convert the value back into a number, by why not simply sort by the original

Re: [sqlite] Ordering looks incorrect

2016-09-14 Thread Clemens Ladisch
David Crayford wrote: > How do I do something similar to DB2 decimal() function which will add > trailing zeros to precision? You could use the standard SQL CAST() to convert the value back into a number, by why not simply sort by the original number to begin with? ORDER BY max(cpu1)

Re: [sqlite] Ordering looks incorrect

2016-09-14 Thread David Crayford
Of course. How do I do something similar to DB2 decimal() function which will add trailing zeros to precision? I tried round(col,6) but it knocked off the trailing zero like 12.12345. On 14/09/2016 9:10 PM, Clemens Ladisch wrote: David Crayford wrote: 9.733366 595.509361 29.117646 28.607606

Re: [sqlite] Ordering looks incorrect

2016-09-14 Thread Dominique Devienne
On Wed, Sep 14, 2016 at 3:10 PM, Clemens Ladisch wrote: > The sort order of these strings looks correct. > As hinted by Clemens, you're sorting text values, not reals. See below. --DD C:\Users\ddevienne>sqlite3 SQLite version 3.10.2 2016-01-20 15:27:19 Enter ".help" for

Re: [sqlite] Ordering looks incorrect

2016-09-14 Thread Simon Slavin
On 14 Sep 2016, at 2:10pm, Clemens Ladisch wrote: > The sort order of these strings looks correct. Heh. Heh heh. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Ordering looks incorrect

2016-09-14 Thread Clemens Ladisch
David Crayford wrote: > 9.733366 > 595.509361 > 29.117646 > 28.607606 > 14.684294 The sort order of these strings looks correct. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org