Skip site navigation (1) Skip section navigation (2)

BUG #3404: Mix ORDER BY ASC With DESC

From: "Maxx" <maxx(at)maxxfonseca(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3404: Mix ORDER BY ASC With DESC
Date: 2007-06-22 19:03:43
Message-ID: 200706221903.l5MJ3hFC039170@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-06-22 19:40:55
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can
Previous:From: Tom LaneDate: 2007-06-22 18:51:31
Subject: Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group