Re: Please help me regarding the WITH RECURSIVE query

On Mon, Aug 26, 2013 at 3:17 AM, gajendra s v <svgajendra(at)gmail(dot)com> wrote:

> Please explain me why it is ?
>

A good place to start would be removing all the parts here that don't seem
to matter. Your problem seems to be with the recursive query (since that is
the part you're changing). Cut off everything else and compare the results
of the recursive queries, and if you still can't figure it out, come back
here with your findings (and the isolated recursive queries). You'll be
much more likely to get responses if you narrow down the problem you're
having instead of asking people on this list to do it.

You might find this a good read: http://sscce.org/. And it wouldn't hurt if
you could create a SQL Fiddle <http://sqlfiddle.com/> that demonstrates
your problem; the simpler and more trimmed down the better.