Re: Can WINDOW be used? - Mailing list pgsql-performance

> wxd0812=# EXPLAIN ANALYZE
> wxd0812-# SELECT * FROM
> wxd0812-#  (SELECT DISTINCT ON (key1_id,key2_id) * FROM sid120.data
> ORDER BY key1_id,key2_id,time_id DESC) x
> wxd0812-#  WHERE NOT deleted;

SELECT * FROM (
     SELECT data.*,
       rank() as rank over
            ( partition by key1_id, key2_id order by time_id DESC )
     FROM data
) as rankings
WHERE rank = 1 AND NOT deleted;


--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com