Re: Aggregates containing outer references don't work per spec

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Aggregates containing outer references don't work per spec
Date: 2003-06-05 17:07:44
Message-ID: 7596.1054832864@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> What is SUM(up1levelvar + up2levelsvar) considered to be? Would that be
> the same as SUM(localvar + outervar) one level up?

Exactly. The spec says that SUM(up1levelvar) is the same as
SUM(localvar) one level up, so this seems a natural generalization.
It lets us keep supporting our old behavior in cases where that behavior
is sensible.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Darko Prenosil 2003-06-05 17:17:18 Re: Linux startup script
Previous Message Jan Wieck 2003-06-05 16:57:47 Re: Aggregates containing outer references don't work per