From bec98a31c55a4f799b398d01541e68d7c086bb81 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 17 Jul 2000 03:05:41 +0000 Subject: Revise aggregate functions per earlier discussions in pghackers. There's now only one transition value and transition function. NULL handling in aggregates is a lot cleaner. Also, use Numeric accumulators instead of integer accumulators for sum/avg on integer datatypes --- this avoids overflow at the cost of being a little slower. Implement VARIANCE() and STDDEV() aggregates in the standard backend. Also, enable new LIKE selectivity estimators by default. Unrelated change, but as long as I had to force initdb anyway... --- src/backend/executor/nodeResult.c | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'src/backend/executor/nodeResult.c') diff --git a/src/backend/executor/nodeResult.c b/src/backend/executor/nodeResult.c index a1daaf52c4b..770cc47ccc4 100644 --- a/src/backend/executor/nodeResult.c +++ b/src/backend/executor/nodeResult.c @@ -34,7 +34,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/executor/nodeResult.c,v 1.14 2000/07/12 02:37:04 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/executor/nodeResult.c,v 1.15 2000/07/17 03:04:53 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -43,6 +43,8 @@ #include "executor/executor.h" #include "executor/nodeResult.h" +#include "utils/memutils.h" + /* ---------------------------------------------------------------- * ExecResult(node) -- cgit v1.2.3