作者
digoal
日期
2021-03-07
标签
PostgreSQL , bit_xor , bit_and , bit_or
背景
bit_xor聚合函数通常被用于做无序数据集合的checksum.
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f9a0392e1cf36179c984f655a6589734b8dd7468
```
Add bit_xor aggregate function master github/master
author Peter Eisentraut peter@eisentraut.org
Sat, 6 Mar 2021 18:25:45 +0000 (19:25 +0100)
committer Peter Eisentraut peter@eisentraut.org
Sat, 6 Mar 2021 18:28:05 +0000 (19:28 +0100)
commit f9a0392e1cf36179c984f655a6589734b8dd7468
tree 72cf42d84a56ebc5cb99caa648bffe2c2110147a tree | snapshot
parent 30b26dfac7db2fc76dafaa8a6c459871bfcd100e commit | diff
Add bit_xor aggregate function
This can be used as a checksum for unordered sets. bit_and and bit_or
already exist.
Author: Alexey Bashtanov bashtanov@imap.cc
Reviewed-by: Ibrar Ahmed ibrar.ahmad@gmail.com
Discussion: https://www.postgresql.org/message-id/flat/9d4582ae-ecfc-3a13-2238-6ab5a37c1f41@imap.cc
```
PostgreSQL 许愿链接
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
9.9元购买3个月阿里云RDS PostgreSQL实例
PostgreSQL 解决方案集合
德哥 / digoal's github - 公益是一辈子的事.
