Agenda Discovery Week Month

Curated for Me

WEST - Postgres Window Magic

See the Events in the EventUpon Database

My Search Results within
25
miles of
My Event List Results within
25
miles of
My Search Results within
25
miles of
My Event List Results within
25
miles of
Endorsed by Curators:
Apr 25 6:00PM - 7:00PM

Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.


About the Speaker

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group and has worked on PostgreSQL since 1996 as a committer and community leader. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Bruce is employed by EnterpriseDB as a Senior Database Architect.

Upcoming Events