ydb
ydb copied to clipboard
Feature request: ListPushBack/ListPushFront
Ability to add single element to list without wrapping it to a list:
SELECT ListPushBack(aaa, val) FROM (SELECT [1,2,3] AS aaa, 5 as val);
[1,2,3,5]
Current approach:
SELECT ListExtend(aaa, [val]) FROM (SELECT [1,2,3] AS aaa, 5 as val);
[1,2,3,5]
SELECT ListPushFront(aaa, val) FROM (SELECT [1,2,3] AS aaa, 5 as val);
[5,1,2,3]
Current approach:
SELECT ListExtend([val], aaa) FROM (SELECT [1,2,3] AS aaa, 5 as val);
[5,1,2,3]
It can save quite a bit of cpu on avoiding casting of value to a list.