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 expected... sqlite> SELECT * FROM news ORDER BY year DESC,month DESC,day DESC; 2007|7|7|Novo design|... 2007|6|19|10.000 palavras|... 2007|7|15|Actualização das regras de transcrição|... What am I doing wrong? Thank you Kind regards Alberto -- Alberto Simões ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------