search

ChenHuajun / pg_roaringbitmap

RoaringBitmap extension for PostgreSQL
Apache License 2.0
223 stars 37 forks source link

support equality operator #24

Open DeoLeung opened 1 year ago

DeoLeung commented 1 year ago

Hi,

I'm using rb in my recursive cte as filter and condition check, however in the result set it can't be used to group by directly.

looks like rb does support =, not sure if it's a bug :)

-- not ok
SELECT count(DISTINCT path) AS count 
        FROM s
-- ok
SELECT count(DISTINCT path::bytea) AS count 
        FROM s
ERROR:  could not identify an equality operator for type roaringbitmap
LINE 20:          SELECT count(DISTINCT path) AS count 
                                        ^
ChenHuajun commented 1 year ago

This feature is not currently supported. hash support may needed