"Josh Harrison" <joshques@xxxxxxxxx> writes: > My question is when I don't use the Recursive term does the optimizer just > consider it as a subquery or does it work like Oracle's WITH CLAUSE > (Subquery Factoring) ? Oracle's WITH CLAUSE boosts the performance of the > queries. So does this do the same? See the fine manual, for instance last para here: http://developer.postgresql.org/pgdocs/postgres/queries-with.html regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general