Postgres Pro
Downloads
Home   >   mailing lists

Re: FILTER clause for non-aggregate window functions - Mailing list pgsql-sql

From Tom Lane
Subject Re: FILTER clause for non-aggregate window functions
Date
Msg-id 32701.1513092905@sss.pgh.pa.us
Whole thread Raw
In response to FILTER clause for non-aggregate window functions  (Андрей Жиденков <pensnarik@gmail.com>)
Responses Re: FILTER clause for non-aggregate window functions  (Андрей Жиденков <pensnarik@gmail.com>)
List pgsql-sql
Tree view 
=?UTF-8?B?0JDQvdC00YDQtdC5INCW0LjQtNC10L3QutC+0LI=?= <pensnarik@gmail.com> 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

pgsql-sql by date:

Previous
From: Андрей Жиденков
Date:
Subject: FILTER clause for non-aggregate window functions
Next
From: Андрей Жиденков
Date:
Subject: Re: FILTER clause for non-aggregate window functions