Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: Incorrect sort result caused by ROLLUP and WHERE operation

Re: Incorrect sort result caused by ROLLUP and WHERE operation

From
Zhang Mingli
Date:
Hi,


Zhang Mingli
www.hashdata.xyz

Do you mean order of null value (column a)  is wrong?
Use NULLS FIRST/LAST to order null values.
On Jan 2, 2025 at 18:19 +0800, 谭忠涛 <zhongtao.tan@seaboxdata.com>, wrote:

Case:
create table t1(a int, b int);
insert into t1 values(1,1),(1,2);
select a,b,sum(10) as s from t1 where a = 1 group by rollup(a,b) order by a, s desc;