Ben Lis
Data Engineer at LEI Smart
Some relevant points about me:
- Data Engineer at LEI Smart
- Writes recursive queries on corporate hierarchy data
- Initially found recursive SQL a bit confusing
- PostgreSQL user since 2015; longtime RDBMS user
- Adjunct Associate Faculty in Applied Analytics at Columbia University
- Held various technical, product, and management roles on Wall Street
Upcoming presentations
No upcoming presentations...
Past presentations
- why we need recursive queries
- how they work
- how to write them
Writing Recursive Queries
Retrieving Hierarchy Data From Relational Tables
Recursive queries enable PostgreSQL users to retrieve hierarchical data from relational tables. Attendees learn:
The talk assumes knowledge of SQL through outer joins and a general understanding of programming concepts.
The schema and queries used in the talk are available for download at https://github.com/benjli...
@ Postgres Conference
Mar 20 2019
Data