It's a well known fact that one of the more difficult things to do in SQL is deal with nested sets. While SQL has been extended to deal specifically with this problem, it is awkward to work with and (even worse) PostgreSQL doesn't have it yet. A patch to add WITH to Postgres has been suspended in the queue indefinitely because of severe implementation problems. As it turns out, this doesn't really matter because we have a first class stored procedure language which is the preferred way to deal with these problems anyways.
Link
Posted by Tim at April 2, 2008 02:57 PM
| TrackBack
