The following bug has been logged online:
Bug reference: 3404
Logged by: Maxx
Email address: maxx(at)maxxfonseca(dot)com
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