About
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
Ben Lis has presented the following presentations
- why we need recursive queries
- how they work
- how to write them
Writing Recursive Queries
at
Postgres Conference
Retrieving Hierarchy Data From Relational Tables
presented by Ben Lis
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...
more Wed 20 2019 Data