On Sun, 2003-11-02 at 19:42, Mark Stosberg wrote: > On 2003-10-22, Timo <[EMAIL PROTECTED]> wrote: > > > > You can't have any recursion in an pure sql-query, can you? > > It depends on how you think of recursion, I'd say. You join on the same > table a number of times, by giving it a different alias each time. You > have to manually specify (or generate with application code) all these > aliases and joins, though. Sometimes people use this technique to > implement tree structures in SQL.
Not to mention the WITH .. RECURSIVE clause, not yet in PostgreSQL.
signature.asc
Description: This is a digitally signed message part
