Re: order by

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 5/11/23 09:29, Marc Millas wrote:

Hi,

I keep on investigating on the "death postgres" subject

but open a new thread as I don't know if it's related to my pb.

I have 2 different clusters, on 2 different machines, one is prod, the second test.

Same data volumes.

On prod if I do  

select col_a, count(col_a) from table_a group by col_a order by col_a desc, 

I get the numbers of NULL on top.

To get the number of NULL on top on the test db, I have to 

select col_a, count(col_a) from table_a group by col_a order by col_a asc.

    This doesn't answer your question, but: ORDER BY has NULLS { FIRST |
    LAST } options, so no need to completely change the sort order.
    
    And this just confuses your question:
    https://www.postgresql.org/docs/15/sql-select.html
    
> If NULLS LAST is
>         specified, null values sort after all non-null values; if NULLS FIRST is
>         specified, null values sort before all non-null values. If
>         neither is specified, the default behavior is NULLS LAST when ASC is
>           specified or implied, and NULLS FIRST when DESC is
>           specified (thus, the default is to act as though nulls are
>         larger than non-nulls).

--
Born in Arizona, moved to Babylonia.