On 9/16/08, Brian Aker <[EMAIL PROTECTED]> wrote: > > Hi! > > On Sep 16, 2008, at 10:15 PM, Jay Pipes wrote: > > sort (ORDER BY) or compare (WHERE) values in a column based on a >> > > What if you do not have an index but you still want to call ORDERY BY? To > me the collation is a property of the column... and possibly we need one on > the index as well (in the case of INDEX(A,B).
It makes baby Jesus cry when developers order by a field not in an index. Well, not really, but it makes me fume and post things to www.dbawtf.com. 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). 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<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-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
