Thread: Doc: Fixed the result of the bit_count example

Doc: Fixed the result of the bit_count example

From
"wangzk.fnstxz@fujitsu.com"
Date:

Hello:

There is a small problem with the documentation for the previously added SQL function
bit_count.

In the doc, (https://www.postgresql.org/docs/14/functions-binarystring.html)

bit_count('\x1234567890'::bytea) result is "31" , but the actual result is "15".


Similar problems have been fixed in test file (commit: ebedd0c78fc51c293abe56e99a18c67af14da0c9),  but the doc has not been modified.

Regards,

Wang

Attachment

Re: Doc: Fixed the result of the bit_count example

From
Daniel Gustafsson
Date:
> On 29 Jul 2021, at 11:23, wangzk.fnstxz@fujitsu.com wrote:
>
> Hello:
>
> There is a small problem with the documentation for the previously added SQL function “bit_count”.
>
> In the doc, (https://www.postgresql.org/docs/14/functions-binarystring.html)
> “bit_count('\x1234567890'::bytea)” result is "31" , but the actual result is "15".
>
> Similar problems have been fixed in test file (commit: ebedd0c78fc51c293abe56e99a18c67af14da0c9),  but the doc has
notbeen modified. 

Good catch, with the default value of standard_conforming_strings the result is
indeed 15 and should be updated to reflect that.  I'll apply this shortly
backpatched to 14 where bit_count was introduced.

--
Daniel Gustafsson        https://vmware.com/




Re: Doc: Fixed the result of the bit_count example

From
Daniel Gustafsson
Date:
> On 29 Jul 2021, at 11:35, Daniel Gustafsson <daniel@yesql.se> wrote:

> I'll apply this shortly backpatched to 14 where bit_count was introduced.


And done, thanks!

--
Daniel Gustafsson        https://vmware.com/