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-bugs||Date: 2002-07-03 06:38:48|
|Subject: Bug #703: granted permisions lost next day|
|Previous:||From: pgsql-bugs||Date: 2002-07-02 19:40:21|
|Subject: Bug #702: NULLs order by bug in 7.2.1|