On Mon, 2005-03-14 at 10:44 +0100, FERREIRA William (COFRAMI) wrote: > so we choice to use a different solution which consist on using the > index of a chapter and its evolution. > if we have this data : > chapter_id | evolution | index > 1 | 0 | 1 > 2 | 0 | 2 > 3 | 0 | 3 > 4 | 1 | 2 > > by using our sort function we obtain this : > chapter_id | evolution | index > 1 | 0 | 1 > 4 | 1 | 2 > 2 | 0 | 2 > 3 | 0 | 3 >
in what way is this different than ... ORDER BY index ASC, evolution DESC; ? gnari ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])