Re: PG 14 release notes, first draft
От | John Naylor |
---|---|
Тема | Re: PG 14 release notes, first draft |
Дата | |
Msg-id | CAFBsxsHVv5g2qDRwBEPVNq2+hhF5qThxS+6_MKaaa4-=xxSQkA@mail.gmail.com обсуждение исходный текст |
Ответ на | PG 14 release notes, first draft (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: PG 14 release notes, first draft
|
Список | pgsql-hackers |
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.
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 <michael@paquier.xyz>
2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization quick check
2020-10-11 [80f8eb79e] Use perfect hash for NFC and NFKC Unicode Normalization quick check
--
В списке pgsql-hackers по дате отправления: