数据仓库服务 GAUSSDB(DWS)-位图函数:rb_to_array(roaringbitmap)

时间:2024-09-24 15:54:40

rb_to_array(roaringbitmap)

描述:rb_build的逆向操作,把roaringBitmap转成int数组。

返回值类型: array

示例:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
SELECT rb_to_array(c) FROM r_row;
rb_to_array
-------------
{1,2,3}
(1 row)
SELECT rb_to_array('\x3a300000010000000000020010000000010002000300');
rb_to_array
-------------
{1,2,3}
(1 row)
support.huaweicloud.com/sqlreference-910-dws/dws_06_0323.html