Thom Brown wrote:
> On 24 August 2010 05:16, Josh Berkus <josh@agliodbs.com> wrote:
> > Bruce, Robert,
> >
> > This patch adds a bunch of feature links to other parts of the docs to the
> > "big features" portion of the release notes. ?I was unable to find an
> > appropriate link for ORDER BY in aggregates; please fill in if you know of
> > one.
> >
> > If there's something wrong with the way I pulled the patch, just let me know
> > and I'll fix it.
> >
> > --
>
> syntax-aggregates
Updated patch applied, with link additions.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Index: doc/src/sgml/release-9.0.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/release-9.0.sgml,v
retrieving revision 2.50
diff -c -c -r2.50 release-9.0.sgml
*** doc/src/sgml/release-9.0.sgml 23 Aug 2010 02:43:25 -0000 2.50
--- doc/src/sgml/release-9.0.sgml 24 Aug 2010 14:45:20 -0000
***************
*** 43,89 ****
<listitem>
<para>
Easier database object permissions management. <link
! linkend="SQL-GRANT"><command>GRANT</>/<command>REVOKE IN
! SCHEMA</></link> supports mass permissions changes on existing objects,
! while <link linkend="SQL-ALTERDEFAULTPRIVILEGES"><command>ALTER DEFAULT
! PRIVILEGES</></link> allows control of privileges for objects created in
! the future. Large objects (BLOBs) now support privilege management as
! well.
</para>
</listitem>
<listitem>
<para>
! Broadly enhanced stored procedure support.
! The <link linkend="SQL-DO"><command>DO</></link> statement permits
! execution of <quote>anonymous</> code blocks, without having to
! define a function first. Functions can now be called using named
! parameters. PL/pgSQL is now installed by default, and PL/Perl and
! PL/Python have been enhanced in several ways, including support for
! Python3.
</para>
</listitem>
<listitem>
<para>
! Full support for <link linkend="install-win32">64-bit
! <productname>Windows</></link>.
</para>
</listitem>
<listitem>
<para>
! More advanced reporting queries, including additional windowing options
! (<literal>PRECEDING</> and <literal>FOLLOWING</>) and the ability to
! control the order in which values are fed to aggregate functions.
</para>
</listitem>
<listitem>
<para>
! New trigger features, including
! SQL-standard-compliant <link
! linkend="SQL-CREATETRIGGER">per-column triggers</link> and
conditional trigger execution.
</para>
</listitem>
--- 43,92 ----
<listitem>
<para>
Easier database object permissions management. <link
! linkend="SQL-GRANT"><command>GRANT</>/<command>REVOKE
! IN SCHEMA</></link> supports mass permissions changes, and
! the <link linkend="SQL-ALTERDEFAULTPRIVILEGES"><command>ALTER
! DEFAULT PRIVILEGES</></link> command controls privileges
! of all newly-created objects. Large object permissions now
! support <command>GRANT</>/<command>REVOKE</> as well.
</para>
</listitem>
<listitem>
<para>
! Add support for compiling on <link
! linkend="install-win32-full">64-bit
! <productname>Windows</></link> and running in 64-bit
! mode.
</para>
</listitem>
<listitem>
<para>
! Broadly enhanced stored procedure support.
! The <link linkend="SQL-DO"><command>DO</></link> statement permits
! ad-hoc or anonymous code blocks. Functions can now be called using named
! parameters. <link linkend="plpgsql">PL/pgSQL</link> is now installed by default,
! and <link linkend="plperl">PL/Perl</link> and <link linkend="plpython">PL/Python</link>
! have been enhanced in several ways, including support for Python3.
</para>
</listitem>
<listitem>
<para>
! More advanced reporting queries with additional <link
! linkend="functions-window">window functions</link>
! (<literal>PRECEDING</> and <literal>FOLLOWING</>) and the ability
! to <link linkend="syntax-aggregates"><literal>ORDER BY</></link>
! inside aggregate functions.
</para>
</listitem>
<listitem>
<para>
! Triggers now support two new features,
! SQL-compliant <link
! linkend="SQL-CREATETRIGGER">per-column triggers</link>, and
conditional trigger execution.
</para>
</listitem>
***************
*** 98,168 ****
<listitem>
<para>
! <link linkend="ddl-constraints-exclusion">Exclusion constraints</link>.
! These provide a generalized version of unique constraints, allowing
! enforcement of complex conditions.
</para>
</listitem>
<listitem>
<para>
! New and enhanced security features, including RADIUS authentication,
! LDAP authentication improvements, and a new contrib module
! <link linkend="passwordcheck"><filename>passwordcheck</></link>
! for testing password strength.
</para>
</listitem>
<listitem>
<para>
! New high-performance implementation of the
! <link linkend="SQL-LISTEN"><command>LISTEN</></link>/<link
! linkend="SQL-NOTIFY"><command>NOTIFY</></link> feature.
! Pending events are now stored in a memory-based queue rather than
! a table. Also, a <quote>payload</> string can be sent with each
! event, rather than transmitting just an event name as before.
</para>
</listitem>
<listitem>
<para>
! New implementation of
! <link linkend="SQL-VACUUM"><command>VACUUM FULL</></link>.
! This command now rewrites the entire table and indexes, rather than
! moving individual rows to compact space. It is substantially faster
! in most cases, and no longer results in index bloat.
</para>
</listitem>
<listitem>
<para>
! New contrib module
! <link linkend="pgupgrade"><filename>pg_upgrade</></link>
! to support in-place upgrades from 8.3 or 8.4 to 9.0.
</para>
</listitem>
<listitem>
<para>
! Multiple performance enhancements for specific types of queries,
! including elimination of unnecessary joins. This helps optimize some
! automatically-generated queries, such as those produced by
! object-relational mappers (ORMs).
</para>
</listitem>
<listitem>
<para>
! <link linkend="SQL-EXPLAIN "><command>EXPLAIN</></link> enhancements.
! The output is now available in JSON, XML, or YAML format, and includes
buffer utilization and other data not previously available.
</para>
</listitem>
<listitem>
<para>
! <link linkend="hstore"><filename>hstore</></link> improvements,
! including new functions and greater data capacity.
</para>
</listitem>
--- 101,168 ----
<listitem>
<para>
! New and enhanced security features, including <link linkend="client-authentication">RADIUS
authentication</link>,
! LDAP authentication improvements, and the new <link linkend="passwordcheck">passwordcheck</link> optional
module
! for testing password strength.
</para>
</listitem>
<listitem>
<para>
! The <link linkend="SQL-LISTEN"><command>LISTEN</></link>/<link
! linkend="SQL-NOTIFY"><command>NOTIFY</></link>
! feature has been overhauled to make it into
! a high-performance event queuing system. It now stores
! events in a memory-based queue, and it now allows delivery
! of a string payload to listeners with each event.
</para>
</listitem>
<listitem>
<para>
! Add <link linkend="pgupgrade"><filename>/contrib/pg_upgrade</></link>
! to support in-place upgrades from 8.3 or 8.4 to 9.0.
</para>
</listitem>
<listitem>
<para>
! Multiple performance enhancements for specific types of queries,
! including join elimination, which optimizes automatically generated
! queries, such as those produced by object-relational mappers (ORMs).
</para>
</listitem>
<listitem>
<para>
! <link linkend="ddl-constraints-exclusion">Exclusion constraints</link>
! let database designers define uniqueness based on complex
! criteria, including for non-scalar data such as time periods,
! ranges and arrays.
</para>
</listitem>
<listitem>
<para>
! As part of our decade-long effort to eliminate the pain of VACUUM,
! <link linkend="vacuum-for-space-recovery"><command>VACUUM FULL</></link>
! is now substantially faster by rewriting the entire table and
! indexes, rather than moving around single rows to compact space.
</para>
</listitem>
<listitem>
<para>
! <link linkend="using-explain"><command>EXPLAIN</command></link>
! plans are now available in JSON, XML and YAML format, and include
buffer utilization and other data not previously available.
</para>
</listitem>
<listitem>
<para>
! The <link linkend="hstore">HStore optional module</link> has been improved with new functions and greater
! data capacity to make it a high-performance key-value store.
</para>
</listitem>
***************
*** 1653,1659 ****
<listitem>
<para>
! Allow aggregate functions to use <literal>ORDER BY</> (Andrew
Gierth)
</para>
--- 1653,1660 ----
<listitem>
<para>
! Allow aggregate functions to use <link
! linkend="syntax-aggregates"><literal>ORDER BY</></> (Andrew
Gierth)
</para>