git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Add bit_count SQL function

author Peter Eisentraut <peter@eisentraut.org>

2021年3月23日 07:45:51 +0000 (08:45 +0100)

committer Peter Eisentraut <peter@eisentraut.org>

2021年3月23日 09:13:58 +0000 (10:13 +0100)

commit a6715af1e72da289474011be1e2d536f991eda34

tree 48ae8ef2c5c858baf43611b8a65c4ec22cbe47bf tree

parent 5aed6a1fc214913de9ac69c1717dc64a2483e16d commit | diff

Add bit_count SQL function

This function for bit and bytea counts the set bits in the bit or byte
string. Internally, we use the existing popcount functionality.

For the name, after some discussion, we settled on bit_count, which
also exists with this meaning in MySQL, Java, and Python.

Author: David Fetter <david@fetter.org>
Discussion: https://www.postgresql.org/message-id/flat/20201230105535.GJ13234@fetter.org

doc/src/sgml/func.sgml diff | blob | blame | history

src/backend/utils/adt/varbit.c diff | blob | blame | history

src/backend/utils/adt/varlena.c diff | blob | blame | history

src/include/catalog/catversion.h diff | blob | blame | history

src/include/catalog/pg_proc.dat diff | blob | blame | history

src/test/regress/expected/bit.out diff | blob | blame | history

src/test/regress/expected/strings.out diff | blob | blame | history

src/test/regress/sql/bit.sql diff | blob | blame | history

src/test/regress/sql/strings.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom