pgsql: Document evaluation-order considerations for aggregate functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Document evaluation-order considerations for aggregate functions
Date: 2014-11-14 22:20:08
Message-ID: E1XpPDs-0000Yo-PA@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Document evaluation-order considerations for aggregate functions.

The SELECT reference page didn't really address the question of when
aggregate function evaluation occurs, nor did the "expression evaluation
rules" documentation mention that CASE can't be used to control whether
an aggregate gets evaluated or not. Improve that.

Per discussion of bug #11661. Original text by Marti Raudsepp and Michael
Paquier, rewritten significantly by me.

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/df3e23e1b509001ac9336763404406bdcad04dcc

Modified Files
--------------
doc/src/sgml/ref/select.sgml | 36 ++++++++++++++++++++++++++----------
doc/src/sgml/syntax.sgml | 22 ++++++++++++++++++++++
2 files changed, 48 insertions(+), 10 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2014-11-15 00:34:19 pgsql: Ensure unlogged tables are reset even if crash recovery errors o
Previous Message Stephen Frost 2014-11-14 22:05:25 pgsql: Clean up includes from RLS patch