"Julien Theulier" <julien@xxxxxxxxxxxxxxxxxx> writes: > Teradata provides a ?qualify? syntax which works as a filtering condition on > a windowed function result. This is the only DB allowing this direct > filtering on windowed functions, from what I know. Seems like you could easily translate that into SQL-standard syntax by adding a level of sub-select: select ... from (select *, window_function wf from ...) ss where wf=1; regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
