Re: FILTER clause for non-aggregate window functions

Tom Lane <[email protected]>
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]> 
=?UTF-8?B?0JDQvdC00YDQtdC5INCW0LjQtNC10L3QutC+0LI=?= <[email protected]> writes:
> Why FILTER is not implemented for non-aggregate functions?

The SQL standard only describes FILTER for aggregates.  I'm not sure
offhand whether it'd be semantically sensible for window functions.
In any case, seems like most of the cases where you'd want it can be
expressed equally well by putting the restriction into WHERE.

			regards, tom lane
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.