On Thu, Aug 11, 2011 at 12:48, Edward W. Rouse wrote:
> How about SELECT cat_name, sum(amount) AS "amount" FROM category,
> trans_details WHERE category_cat_id in (select cat_id from category where
> lineage ~ ‘^1’)
>
> ** **
>
> Where the in clause is basically, the cat_id where lineage start
1 11:39 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] Stuck Up In My Own Category Tree
Hi all,
Note: I'm happy to read howtos, tutorials, archived messages - I just
haven't found anything that addresses this yet. I found a related topic on
the novice list, but my post got no respons
: Thu, 11 Aug 2011 09:24:41
To: Don Parris
Cc:
Subject: Re: [SQL] Stuck Up In My Own Category Tree
On Thu, Aug 11, 2011 at 8:39 AM, Don Parris wrote:
> Hi all,
>
> Note: I'm happy to read howtos, tutorials, archived messages - I just
> haven't found anything that addresses t
On Thu, Aug 11, 2011 at 8:39 AM, Don Parris wrote:
> Hi all,
>
> Note: I'm happy to read howtos, tutorials, archived messages - I just
> haven't found anything that addresses this yet. I found a related topic on
> the novice list, but my post got no response there. I've been struggling
> with t
Hi all,
Note: I'm happy to read howtos, tutorials, archived messages - I just
haven't found anything that addresses this yet. I found a related topic on
the novice list, but my post got no response there. I've been struggling
with this for about a week now and need to figure out a solution. Hec
