[sqlite] Re: Help with order-by query

Alberto Simões <[EMAIL PROTECTED]> wrote: I have this simple schema for news: sqlite> .schema CREATE TABLE news (year,month,day,title,text); CREATE INDEX date ON news(year,month,day); And this query results not as expected... sqlite> SELECT * FROM news ORDER BY year DESC,month DESC,day DESC;

[sqlite] Re: Help with order-by query

Ok, my fault. Integers versus string values. Cheers Alberto On 7/15/07, Alberto Simões <[EMAIL PROTECTED]> wrote: Hi I have this simple schema for news: sqlite> .schema CREATE TABLE news (year,month,day,title,text); CREATE INDEX date ON news(year,month,day); And this query results not as