> Good morning, dear friends.
>
> In sorting by DESC null in up and ASC ‘’ in up, why them not near?
>
> Respectfully yours, okijhhyu
NULLS are not empty values but undefined values. Nevertheless, in
PostgreSQL there is the following default order for their sorting: "By
default, null values sort as if larger than any non-null value; that
is, NULLS FIRST is the default for DESC order, and NULLS LAST
otherwise." (https://www.postgresql.org/docs/current/queries-order.html).
Nulls ordering can be changed by. The NULLS FIRST and NULLS LAST
options can be used to determine whether nulls appear before or after
non-null values in the sort ordering.
Do you see this or something contrary to?
Best regards,
Pavel Borisov,
Supabase