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;
20
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 expe
2 matches
Mail list logo