View Issue Details

IDProjectCategoryView StatusLast Update
0002196Database Workbench v6PostgreSQL Modulepublic2024-05-13 14:27
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version6.5.0 
Summary0002196: Support for PostgreSQL 16.0 & 16.1 & 16.2
Descriptionhttps://www.postgresql.org/docs/release/

https://www.postgresql.org/docs/release/16.0/
- Allow subqueries in the FROM clause to omit aliases
- Add SQL/JSON constructors new functions JSON_ARRAY(), JSON_ARRAYAGG(), JSON_OBJECT(), and JSON_OBJECTAGG()
- Add SQL/JSON object checks https://www.postgresql.org/docs/16/functions-json.html#FUNCTIONS-SQLJSON-MISC
- Add functions to add, subtract, and generate timestamptz values in a specified time zone functions are date_add(), date_subtract(), and generate_series() https://www.postgresql.org/docs/16/functions-datetime.html#FUNCTIONS-DATETIME-TABLE
- Add server variable SYSTEM_USER
- Add functions array_sample() and array_shuffle() https://www.postgresql.org/docs/16/functions-array.html#ARRAY-FUNCTIONS-TABLE
- Add aggregate function ANY_VALUE() https://www.postgresql.org/docs/16/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE
- Add function random_normal() https://www.postgresql.org/docs/16/functions-math.html#FUNCTIONS-MATH-RANDOM-TABLE
- Add error function erf() and its complement erfc() https://www.postgresql.org/docs/16/functions-math.html#FUNCTIONS-MATH-FUNC-TABLE
- Add XMLSERIALIZE() https://www.postgresql.org/docs/16/datatype-xml.html#DATATYPE-XML-CREATING

https://www.postgresql.org/docs/release/16.1/
- // nothing special

https://www.postgresql.org/docs/release/16.2/
- // nothing special
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2024-01-30 09:55 Martijn Tonies New Issue
2024-03-07 10:01 Martijn Tonies Summary Support for PostgreSQL 16.0 & 16.1 => Support for PostgreSQL 16.0 & 16.1 & 16.2
2024-03-07 10:01 Martijn Tonies Description Updated
2024-03-11 11:03 Martijn Tonies Assigned To => Martijn Tonies
2024-03-11 11:03 Martijn Tonies Status new => resolved
2024-03-11 11:03 Martijn Tonies Resolution open => fixed
2024-03-11 11:03 Martijn Tonies Fixed in Version => 6.5.0
2024-05-13 14:27 Martijn Tonies Status resolved => closed