Re: Reuse of State value in Aggregates - Mailing list pgsql-hackers

From Antonin Houska
Subject Re: Reuse of State value in Aggregates
Date
Msg-id 45167.1636530012@antos
Whole thread Raw
In response to Reuse of State value in Aggregates  (gg pw <lucenaalmirjames123@gmail.com>)
Responses Re: Reuse of State value in Aggregates
List pgsql-hackers
gg pw <lucenaalmirjames123@gmail.com> wrote:

> Do Aggregate functions/queries reuse the state value they generate for subsequent queries? If not then an explanation
wouldbe greatly appreciated.  

The subsequent queries are not supposed to feed the same input into the
aggregates, so their aggregate states will most likely be different. Maybe you
need to post an example where you think such reusing would be useful.

--
Antonin Houska
Web: https://www.cybertec-postgresql.com



pgsql-hackers by date:

Previous
From: Greg Nancarrow
Date:
Subject: Re: On login trigger: take three
Next
From: Dilip Kumar
Date:
Subject: Re: Add connection active, idle time to pg_stat_activity