Yes I'm using PostgreSQL and now that you've linked to the docs, I
remember there was a possibility for recursion. Thanks for suggestion,
I'll look into it.
.oO V Oo.
On 08/02/2011 03:41 AM, Gunnlaugur Briem wrote:
You could look for recursive CTE (Common Table Expressions), if your
You could look for recursive CTE (Common Table Expressions), if your
database engine supports such queries. See e.g.
http://www.postgresql.org/docs/8.4/static/queries-with.html for PostgreSQL.
That allows arbitrary-depth queries, as opposed to join chains that have to
assume a fixed depth. You