Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug in aggregates in windowing context - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in aggregates in windowing context
Date
Msg-id 8949.1252535705@sss.pgh.pa.us
Whole thread Raw
In response to Bug in aggregates in windowing context  (David Fetter <david@fetter.org>)
Responses Re: Bug in aggregates in windowing context
List pgsql-hackers
Tree view 
David Fetter <david@fetter.org> writes:
> SELECT count(DISTINCT i) OVER () FROM (VALUES (1),(2),(3),(1)) AS s(i);
> ERROR:  DISTINCT is not implemented for window functions

Which part of that message isn't clear to you?

> Anyhow, I think it's a bug and needs back-patching.

"Not implemented" is not a bug.  Nice try though.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: RfD: more powerful "any" types
Next
From: David Fetter
Date:
Subject: Re: Bug in aggregates in windowing context