Hi Bruce,

Thanks for doing this work again!

> Add date_bin function (John Naylor)
>
> WHAT DOES THIS DO?

Hard to describe in a one-liner, but it lines up timestamps into regular
intervals as specified by the user. It is more clear after seeing examples:

https://www.postgresql.org/docs/devel/functions-datetime.html#FUNCTIONS-DATETIME-BIN

> Dramatically improve Unicode normalization (John Naylor)
>
> WHAT OPERATIONS USE THIS?

PG13 added the normalize() function to normalize Unicode sequences, as well
as the IS NORMALIZED syntax to test for that. The commits* here do not
change behavior and only improve performance. As such, this really belongs
in the performance section.

*There is one additional commit that belongs to this entry:

Author: Michael Paquier <mich...@paquier.xyz>
2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode
Normalization quick check

--
John Naylor
EDB: http://www.enterprisedb.com

Reply via email to