Re: pgsql: Allow setting statistics target for extended statistics

[Andres Freund]

Hi,

On 2019-09-10 22:26:41 +, Tomas Vondra wrote:
> Allow setting statistics target for extended statistics

This appears to have missed a catversion bump. Clearly necessary as the
schema of pg_statistic_ext changed.

- Andres

pgsql: Support for SSSSS datetime format pattern

[Alexander Korotkov]

Support for S datetime format pattern

SQL Standard 2016 defines S format pattern for seconds past midnight in
jsonpath .datetime() method and CAST (... FORMAT ...) SQL clause.  In our
datetime parsing engine we currently support it with  name.

This commit adds S as an alias for .  Alias is added in favor of
upcoming jsonpath .datetime() method.  But it's also supported in to_date()/
to_timestamp() as positive side effect.

Discussion: 
https://postgr.es/m/CAPpHfdsZgYEra_PeCLGNoXOWYx6iU-S3wF8aX0ObQUcZU%2B4XTw%40mail.gmail.com
Author: Nikita Glukhov, Alexander Korotkov
Reviewed-by: Anastasia Lubennikova, Peter Eisentraut

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/b64b857f50fb51da1588c54a56f8fc1c0d491058

Modified Files
--
doc/src/sgml/func.sgml |  2 +-
src/backend/utils/adt/formatting.c | 12 
src/test/regress/expected/horology.out | 20 
src/test/regress/sql/horology.sql  |  4 
4 files changed, 33 insertions(+), 5 deletions(-)

pgsql: Support for FF1-FF6 datetime format patterns

[Alexander Korotkov]

Support for FF1-FF6 datetime format patterns

SQL Standard 2016 defines FF1-FF9 format patters for fractions of seconds in
jsonpath .datetime() method and CAST (... FORMAT ...) SQL clause.  Parsing
engine of upcoming .datetime() method will be shared with to_date()/
to_timestamp().

This patch implements FF1-FF6 format patterns for upcoming jsonpath .datetime()
method.  to_date()/to_timestamp() functions will also get support of this
format patterns as positive side effect.  FF7-FF9 are not supported due to
lack of precision in our internal timestamp representation.

Extracted from original patch by Nikita Glukhov, Teodor Sigaev, Oleg Bartunov.
Heavily revised by me.

Discussion: 
https://postgr.es/m/fcc6fc6a-b497-f39a-923d-aa34d0c588e8%402ndQuadrant.com
Discussion: 
https://postgr.es/m/CAPpHfdsZgYEra_PeCLGNoXOWYx6iU-S3wF8aX0ObQUcZU%2B4XTw%40mail.gmail.com
Author: Nikita Glukhov, Teodor Sigaev, Oleg Bartunov, Alexander Korotkov
Reviewed-by: Anastasia Lubennikova, Peter Eisentraut

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/d589f94460c24d9b7ac21887d031818d6e3f354d

Modified Files
--
doc/src/sgml/func.sgml| 24 
src/backend/utils/adt/formatting.c| 99 ---
src/backend/utils/adt/timestamp.c |  3 +-
src/include/utils/datetime.h  |  2 +
src/test/regress/expected/horology.out| 79 
src/test/regress/expected/timestamp.out   | 15 +
src/test/regress/expected/timestamptz.out | 15 +
src/test/regress/sql/horology.sql |  9 +++
src/test/regress/sql/timestamp.sql|  8 +++
src/test/regress/sql/timestamptz.sql  |  8 +++
10 files changed, 239 insertions(+), 23 deletions(-)