Re: Please help me regarding the WITH RECURSIVE query - Mailing list pgsql-general

From BladeOfLight16
Subject Re: Please help me regarding the WITH RECURSIVE query
Date
Msg-id CA+=1U=UVYz_euw7w5X9r-VoZLdGHbpgY3khMxj=6ZCYrSvgSSQ@mail.gmail.com
Whole thread Raw
In response to Please help me regarding the WITH RECURSIVE query  (gajendra s v <svgajendra@gmail.com>)
List pgsql-general
On Mon, Aug 26, 2013 at 3:17 AM, gajendra s v <svgajendra@gmail.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 that demonstrates your problem; the simpler and more trimmed down the better.

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: how to use aggregate functions in this case
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Replication Postgre > Oracle