Date: 2010-12-07
Time: 09:30–10:15
Room: Glasgow
Historically, there has been a mismatch--some might even say antipathy--between relational databases and graphs, of which trees are the most common example. Until Common Table Expressions came along, there was really no general way to express trees in a relational database, let alone constrain them. In this talk, you'll learn about expressing trees and more importantly, using PostgreSQL's advanced features in a simple, intuitive way to make constraints like, "This table must contain only trees."