BUG #3404: Mix ORDER BY ASC With DESC - Mailing list pgsql-bugs

From Maxx
Subject BUG #3404: Mix ORDER BY ASC With DESC
Date
Msg-id 200706221903.l5MJ3hFC039170@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3404: Mix ORDER BY ASC With DESC
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Brigitte"
Date:
Subject: get rock like the herbal way - \xA0
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can