BUG #3404: Mix ORDER BY ASC With DESC

Started by Maxxalmost 19 years ago2 messagesbugs

maxx@maxxfonseca.com

almost 19 years ago

The following bug has been logged online:

Bug reference: 3404
Logged by: Maxx
Email address: maxx@maxxfonseca.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

Tom Lane

tgl@sss.pgh.pa.us

almost 19 years ago

In reply to: Maxx (#1)

Re: BUG #3404: Mix ORDER BY ASC With DESC

"Maxx" <maxx@maxxfonseca.com> writes:

When I mix the ORDER BY clause with ASC and DESC the return is just the
first field, for example:

You're going to have to provide a complete test case if you want anyone
to take that seriously.

regards, tom lane