Обсуждение: Sort bug
Good morning, dear friends.
In sorting by DESC null in up and ASC ‘’ in up, why them not near?
Respectfully yours, okijhhyu
> On 14 Dec 2022, at 08:20, okijhhyu <okijhhyu@gmail.com> wrote: > In sorting by DESC null in up and ASC ‘’ in up, why them not near? I'm not sure I understand, can you show a small query which exhibits the behavior you believe is buggy and explain what you think should've happened? -- Daniel Gustafsson https://vmware.com/
> 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