I've become addicted to the table expressions available in Postgres 8.4: http://www.postgresql.org/docs/current/static/queries-table-expressions.html

When using them NetBeans SQL editor doesn't seem to be able to handle them. The autocomplete stops working or just suggests 'SELECT | DROP'. 

This is an example of the queries I've been writing. 


WITH latest_foo as
(select * from (select *, rank() over (PARTITION BY user_id order by date desc, id desc) from foo) ranked where rank = 1)

select severity, count(*) from latest_foo 
group by 1