ydb icon indicating copy to clipboard operation
ydb copied to clipboard

Feature request: ListPushBack/ListPushFront

Open UnamedRus opened this issue 3 years ago • 0 comments

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.

UnamedRus avatar May 04 '22 00:05 UnamedRus