Archive for May 29th, 2009
Hierarchical queries in PostgreSQL
Comments enabled. I *really* need your comment
Note: this article concerns PostgreSQL 8.3 and earlier.
For hierarchical queries in PostgreSQL 8.4 and higher, see this article:
In one of the previous articles I wrote about using hierarchical queries in MySQL:
PostgreSQL has a contrib module to implement the same functionality.
However, it's not always possible to install and use contribs. Same is true for procedural languages.
Fortunately, this functionality can be implemented using a plain SQL function.
Let's create a sample table and see how it works:
Read the rest of this entry »
Subscribe in a reader