PostgreSQL 8.4 has radical new capabilities inside the database: Windowing functions and Common Table Expressions. You'll learn about each with practical examples to make your querying days more fun. Time permitting, we'll do some that are less practical.