Hi, > The SQL Grammar page does not indicate whether or not I can specify > whether the index as ascending or descending, yet down below on the > same page, the information schema table shows that a particular index > record has a ASC_OR_DESC field, which makes it sound like this option > is configurable, yet I don't see that in the SQL grammar.
Actually you can, I will document that in the next release (I forgot): drop table test; create table test(id int, name varchar); create index idx_name_desc on test(name desc nulls first); select * from INFORMATION_SCHEMA.INDEXES where table_name = 'TEST'; The ASC_OR_DESC field is required by JDBC API. > I need my timestamps sorted asc, as this is chronological order, and > if this is not the default, I would like to know how to change it. Ascending is the default. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
