Исходное сообщение
"Выпущена первая бета PostgreSQL 8.4" Отправлено funny_falcon, 16-Апр-09 01:20
Вот это ещё круче: # Support set-returning functions in SELECT result lists even for functions that return their result via a tuplestore (Tom)   In particular, this means that functions written in PL/PgSQL and other PL languages can now be called this way. # Support set-returning functions in the output of aggregation and grouping queries (Tom) # Allow comparison of composite types and allow arrays of anonymous composite types (Tom)   This allows constructs such as row(1, 1.1) = any (array[row(7, 7.7), row(1, 1.0)]). This is particularly useful in recursive queries. # Add support for column-level privileges (Stephen Frost, KaiGai Kohei) # Allow CREATE OR REPLACE VIEW to add columns to the end of a view (Robert Haas) # Support multi-column GIN indexes (Teodor Sigaev) Вот ещё приятная вещь: # Add new aggregate function array_agg(), which returns all aggregated values as a single array (Robert Haas, Jeff Davis, Peter) # Add unnest(), which converts an array to individual row values (Tom)   This is the opposite of array_agg(). # Add quote_nullable(), which behaves like quote_literal() but returns the string NULL for a null argument (Brendan Jurd) # Add suppress_redundant_updates_trigger() trigger function to prevent non-data-changing updates (Andrew) # Add TIMESTAMP and TIMESTAMPTZ versions of generate_series() (Hitoshi Harada)