You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
function least and greateast default operation nulls value ,whether operate nulls value should up
to user .
-- current select least(1,2,3,NULL) little,greatest(1,2,3,null) big;
vkingnew
changed the title
[Feature] function least and greateast nulls value operate feature should enhanced
[Feature] least and greatest function enhanced
Sep 2, 2024
function least and greateast default operation nulls value ,whether operate nulls value should up
to user .
-- current
select least(1,2,3,NULL) little,greatest(1,2,3,null) big;
-- expect:
-- desired feature:
least(col1,col2 [ignore|respect] nulls)
greatest(col1,col2 [ignore|respect] nulls)
-- statement example
select least(1,2,3,null ignore nulls) little,greatest(1,2,3,null,IGNORE nulls ) big;
select least(1,2,3,null,respect ignore nulls) little,greatest(1,2,3,null,respect nulls ) big;
The text was updated successfully, but these errors were encountered: