Postgres Pro
Downloads
Home   >   mailing lists

Re: Aggregates containing outer references don't work per spec - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Aggregates containing outer references don't work per spec
Date
Msg-id 7596.1054832864@sss.pgh.pa.us
Whole thread Raw
In response to Re: Aggregates containing outer references don't work per spec  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Jan Wieck <JanWieck@Yahoo.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

pgsql-hackers by date:

Previous
From: Darko Prenosil
Date:
Subject: Re: Linux startup script
Next
From: Jan Wieck
Date:
Subject: Re: Aggregates containing outer references don't work per