Re: Window-functions patch handling of aggregates - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Window-functions patch handling of aggregates
Date
Msg-id 15584.1230327020@sss.pgh.pa.us
Whole thread Raw
In response to Re: Window-functions patch handling of aggregates  ("Robert Haas" <robertmhaas@gmail.com>)
Responses Re: Window-functions patch handling of aggregates  ("Hitoshi Harada" <umi.tanuki@gmail.com>)
List pgsql-hackers
"Robert Haas" <robertmhaas@gmail.com> writes:
> Unfortunately, if we don't want to add an explicit iswindowable flag
> (and I understand that that's ugly), then I think this is the way to
> go.  It's a shame that people will have to make code changes, but
> inventing a fake AggState object just to get around this problem
> sounds worse.  The array_agg code is new and the fact that it doesn't
> follow the design pattern should be considered a bug in that code
> rather than a justification for an ugly workaround.

Well, array_agg may be new but it's simply a re-implementation of a
design pattern that existed in contrib/intagg since 7.3 or so.  I have
no problem with fixing array_agg --- what I'm wondering about is who
has copied intagg before.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Frames vs partitions: is SQL2008 completely insane?
Next
From: Tom Lane
Date:
Subject: Re: Frames vs partitions: is SQL2008 completely insane?