From 55f7c3300d164d370d28b127210223d078da524d Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 17 Mar 2004 20:48:43 +0000 Subject: Reimplement CASE val WHEN compval1 THEN ... WHEN compval2 THEN ... END so that the 'val' is computed only once, per recent discussion. The speedup is not much when 'val' is just a simple variable, but could be significant for larger expressions. More importantly this avoids issues with multiple evaluations of a volatile 'val', and it allows the CASE expression to be reverse-listed in its original form by ruleutils.c. --- src/backend/executor/execUtils.c | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'src/backend/executor/execUtils.c') diff --git a/src/backend/executor/execUtils.c b/src/backend/executor/execUtils.c index b89f4015970..9702b1cf0aa 100644 --- a/src/backend/executor/execUtils.c +++ b/src/backend/executor/execUtils.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/executor/execUtils.c,v 1.109 2004/01/22 02:23:21 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/executor/execUtils.c,v 1.110 2004/03/17 20:48:42 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -306,6 +306,9 @@ CreateExprContext(EState *estate) econtext->ecxt_aggvalues = NULL; econtext->ecxt_aggnulls = NULL; + econtext->caseValue_datum = (Datum) 0; + econtext->caseValue_isNull = true; + econtext->domainValue_datum = (Datum) 0; econtext->domainValue_isNull = true; -- cgit v1.2.3