Hi to all, i have a problem with indexes. For example:
CREATE TABLE T1 (
a text,
b text
);
CREATE INDEX I1 on T1 (a asc, b desc);
1' query:
explain query plan select * from t1 order by a asc, b desc limit 10
output detail-> TABLE T1
2' query:
explain query plan select * from t1 order by a asc, b asc limit 10
output detail-> TABLE T1 WITH INDEX I1 ORDER BY
The only difference between first and second query are the order of the
"b" field.
The "Create Index" docs say:
"Each column name can be followed by one of the "ASC" or "DESC" keywords
to indicate sort order, but the sort order is ignored in the current
implementation. Sorting is always done in ascending order."
But a changelogs say:
"Version 3.3.0 adds support for CHECK constraints, DESC indices, ...."
I use the 3.5.2 version.
What's the status/problem about that?
How i can re-write the first select above to use an index on both fields?
Thanks!
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
