On Tue, Jul 23, 2013 at 1:32 PM, Clemens Ladisch <[email protected]> wrote:
>
>
> But REAL will sort the strings '1', '10', '2' wrong.
>
What do you mean by "wrong"?
The test
CREATE TABLE testtable (id integer primary key, value real);
insert into testtable (value) values ('1');
insert into testtable (value) values ('2');
insert into testtable (value) values ('10');
insert into testtable (value) values ('something');
CREATE INDEX [idx_Testable] ON [testtable] ([Value]);
SELECT * FROM testtable order by value;
will show
1, 2, 10, something
that's what I wanted (except for "something" being exception)
if I change create to
CREATE TABLE testtable (id integer primary key, value);
then the order will be
1, 10, 2, something.
(undesired result)
Max
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
