Hi! > Speaking of which, I believe that indexes aren't allowed to specify ASC or > DESC. This means that if I want to ORDER BY foo ASC, bar DESC I can't use > the index to do the ordering. Will Drizzle fix this? (I'm OK with the > default being parity -- ASC ASC and DESC DESC, but there should be away to > achive non-parity, ASC DESC and DESC ASC).
ASC and DESC for index columns is non-standard. If it is allowed or not is thus DBMS specific > >> Cheers, >> -Brian >> >> >> -- >> _______________________________________________________ >> Brian "Krow" Aker, brian at tangent.org >> Seattle, Washington >> http://krow.net/ <-- Me >> http://tangent.org/ <-- Software >> _______________________________________________________ >> You can't grep a dead tree. >> >> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp > > > > -- > - Sheeri K. Cabral > > Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a > remote DBA firm, and consulting would constitute a conflict of > interest. However, I do recommend our work, and if you're looking for DBA > work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) > right now, whether you need a few hours a week, or someone fulltime while > you continue a job search. > > I have a webpage with tips on how to find a > DBA: http://sheeri.net/how-to-find-a-dba/ > I can recommend http://www.toomanyconnections.com as a good site to find > MySQL (and Oracle) DBAs. > If you're looking for web design, I recommend the small business my husband > works for, http://www.digital-loom.com > I regret that I have no other information for any other type of position, > including developer, programmer and systems administrator. > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
