Table of Contents Previous Next


2 EDB Postgres Advanced Server v12 Features

For better Redwood compatibility, Advanced Server now treats the SELECT UNIQUE clause synonymous to SELECT DISTINCT clause (i.e. they can be used interchangeably in all places).
Advanced Server now supports COMPOUND TRIGGERS. This provides a way to define a single trigger on a table that enables the user to specify actions for different DML event points. It allows defining BEFORE STATEMENT, AFTER STATEMENT, BEFORE EACH ROW, AFTER EACH ROW timing events in a single trigger.
Advanced Server now provides CAST(MULTISET..). CAST(MULTISET) is an extension to the redwood style casting function CAST(.. AS ..) where the subquery result is like a table output CAST to a collection type.
The LISTAGG function supports string aggregation that concatenates data from multiple rows into a single row in an ordered fashion.
The MEDIAN function calculates a median value from the set of provided values. The aggregate function can be used with numeric, date/time and interval types and much like other aggregate functions, it can be used with window function as well.
In addition to supporting %type and %rowtype variables for functions and procedures, Advanced Server now supports the same inside a package as well.
Advanced Server now supports a Redwood compatible to_timestamp implementation, which facilitates stricter input string parsing for timestamp columns for EDB Loader.
Advanced Server has added the SYS_GUID function to generate and return a globally unique identifier in the form of 16-bytes of RAW data.

2 EDB Postgres Advanced Server v12 Features

Table of Contents Previous Next