View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002196 | Database Workbench v6 | PostgreSQL Module | public | 2024-01-30 09:55 | 2024-03-11 11:03 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | feature | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Fixed in Version | v6_next | ||||
| Summary | 0002196: Support for PostgreSQL 16.0 & 16.1 & 16.2 | ||||
| Description | https://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 | ||||
| Tags | No tags attached. | ||||
| 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 | => v6_next |
