20210307_01.md

PostgreSQL 14 preview - 新增 bit_xor 聚合函数

作者

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 <[email protected]>	  
Sat, 6 Mar 2021 18:25:45 +0000 (19:25 +0100)  
committer	Peter Eisentraut <[email protected]>	  
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 <[email protected]>  
Reviewed-by: Ibrar Ahmed <[email protected]>  
Discussion: https://www.postgresql.org/message-id/flat/[email protected]  

PostgreSQL 许愿链接

您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.

9.9元购买3个月阿里云RDS PostgreSQL实例

PostgreSQL 解决方案集合

德哥 / digoal's github - 公益是一辈子的事.

PolarDB 学习图谱: 训练营、培训认证、在线互动实验、解决方案、生态合作、写心得拿奖品

购买PolarDB云服务折扣活动进行中, 55元起

About 德哥