数据仓库服务 GaussDB(DWS)-Roaring Bitmap函数:rb_to_array(roaringbitmap)

时间:2025-02-12 15:05:10

rb_to_array(roaringbitmap)

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

返回值类型: array

示例:

 1 2 3 4 5 6 7 8 910
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-dws/dws_06_0323.html