Here is another peeve Having to specify the type of a constant in a SELECT DISTINCT 'foo'...
I which I had more spare time to contribute... Jean-Luc Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > In fact, I am unsure why you are specifying the primary column in the > > ORDER BY anyway if you know it will be a single value, except perhaps to > > try and get it to use the index, right? > > Exactly. The sort ordering of the index is (col1,col2) while the > query as originally written wanted an ordering of (col2 desc). > The planner's not smart enough to realize that since the WHERE > constrains col1 to a single value, you could pretend the query > requests an ordering of (col1 desc, col2 desc) which is compatible > with the index. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])