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

Re: Bug #702: NULLs order by bug in 7.2.1

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <johnl(at)emrx(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #702: NULLs order by bug in 7.2.1
Date: 2002-07-03 06:11:17
Message-ID: 20020702230327.R3117-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, 2 Jul 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> John Liu (johnl(at)emrx(dot)com) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> NULLs order by  bug in 7.2.1
>
> Long Description
> select date_fld from my_table order by date_fld desc;
>
> The above query put NULLs on top of normal values
> in stead of bottom, this is not the case in 7.1.3.

I think this was the bug fix.  I read the applicable
section of the spec as saying that NULLs are treated
as either all greater or all less than non-null values
for order by, so if the nulls come at the end of an asc
order by, they come at the front of the desc one.





In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-07-03 06:38:48
Subject: Bug #703: granted permisions lost next day
Previous:From: pgsql-bugsDate: 2002-07-02 19:40:21
Subject: Bug #702: NULLs order by bug in 7.2.1

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