The following bug has been logged online: Bug reference: 3404 Logged by: Maxx Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Debian GNU/Linux 4.0 (Etch) Description: Mix ORDER BY ASC With DESC Details:
When I mix the ORDER BY clause with ASC and DESC the return is just the first field, for example: "SELECT * FROM test ORDER BY id DESC, textbody ASC" return the fields only sorted by id desc. But, if I use ORDER BY id DESC, textbody DESC then its works. Thank you for your attention ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate