A couple remarks on TODO

#1 (**permalink**) 04-12-2008, 03:45 AM

TODO has an entry

o Allow UPDATE to handle complex aggregates [update]?

which I think is now obsolete, because we've settled on rejecting
aggregates at the top level of UPDATE, as the spec tells us to do.

Also, there's one remaining unfinished feature in the multi-argument
aggregate patch, which I think we should have a TODO item for:

* Allow DISTINCT to work in multiple-argument aggregate calls

The SQL2003 spec doesn't require this (it forbids DISTINCT in all its
two-argument aggregates) but it seems like we should do it someday
for orthogonality's sake.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#2 (**permalink**) 04-12-2008, 03:45 AM

Thanks, done.

---------------------------------------------------------------------------

Tom Lane wrote:
> TODO has an entry
>
> o Allow UPDATE to handle complex aggregates [update]?
>
> which I think is now obsolete, because we've settled on rejecting
> aggregates at the top level of UPDATE, as the spec tells us to do.
>
> Also, there's one remaining unfinished feature in the multi-argument
> aggregate patch, which I think we should have a TODO item for:
>
> * Allow DISTINCT to work in multiple-argument aggregate calls
>
> The SQL2003 spec doesn't require this (it forbids DISTINCT in all its
> two-argument aggregates) but it seems like we should do it someday
> for orthogonality's sake.
>
> regards, tom lane

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode