Re: Reuse of State value in Aggregates

2021-11-14 Thread gg pw
That's sufficient information for me thanks! I don't really have a concrete example at the moment. The idea just popped up in my head when I read that CTEs are reused inside parent queries.

Re: Reuse of State value in Aggregates

2021-11-09 Thread Antonin Houska
gg pw wrote: > Do Aggregate functions/queries reuse the state value they generate for > subsequent queries? If not then an explanation would be greatly appreciated. The subsequent queries are not supposed to feed the same input into the aggregates, so their aggregate states will most likely be

Reuse of State value in Aggregates

2021-11-09 Thread gg pw
Do Aggregate functions/queries reuse the state value they generate for subsequent queries? If not then an explanation would be greatly appreciated.