X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 3DBCA3A5D6B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 12 Jan 2005 17:53:55 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 52255-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 12 Jan 2005 17:53:46 +0000 (GMT)
Received: from lothos.nuvio.com (lothos.ojc.nuvio.com [63.77.68.101])
	by svr1.postgresql.org (Postfix) with ESMTP id B47AA3A5D38
	for <pgsql-sql@postgresql.org>; Wed, 12 Jan 2005 17:53:46 +0000 (GMT)
Received: from [63.77.68.30] ([63.77.68.30]) by lothos.nuvio.com with
	Microsoft SMTPSVC(5.0.2195.6713); Wed, 12 Jan 2005 11:55:12 -0600
Mime-Version: 1.0 (Apple Message framework v619)
To: pgsql-sql@postgresql.org
Message-Id: <DC7E60F8-64C2-11D9-BEEF-000D932ED682@nuvio.com>
Content-Type: multipart/alternative; boundary=Apple-Mail-7-543671811
From: Bradley Miller <bmiller@nuvio.com>
Subject: Recursive query to be used in another result ?
Date: Wed, 12 Jan 2005 11:53:26 -0600
X-Mailer: Apple Mail (2.619)
X-OriginalArrivalTime: 12 Jan 2005 17:55:12.0890 (UTC)
	FILETIME=[DD5B8DA0:01C4F8CF]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.785 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200501/64
X-Sequence-Number: 19852


--Apple-Mail-7-543671811
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed

I need some help on the following problem.  I have an account info 
table that has a hierarchy of accounts.  The grouping goes from end 
user to organization to reseller.  I have a PL/SQL function written 
that gives me the tree, so I just whittle it down by selecting the one 
id for a reseller:

select account_id from roll_account(1186) where hierarchy_type_id = 2

The problem is I want to have that account_id number (1186) to be 
selected from my main query.  (IE:  select account_id from 
account_info)

Can anyone offer some solutions to this problem?


Bradley Miller
NUVIO CORPORATION
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
http://www.nuvio.com
bmiller@nuvio.com
--Apple-Mail-7-543671811
Content-Transfer-Encoding: 7bit
Content-Type: text/enriched;
	charset=US-ASCII

I need some help on the following problem.  I have an account info
table that has a hierarchy of accounts.  The grouping goes from end
user to organization to reseller.  I have a PL/SQL function written
that gives me the tree, so I just whittle it down by selecting the one
id for a reseller:


select account_id from roll_account(1186) where hierarchy_type_id = 2


The problem is I want to have that account_id number (1186) to be
selected from my main query.  (IE:  select account_id from
account_info)


Can anyone offer some solutions to this problem?



Bradley Miller

<bold><fontfamily><param>Arial</param><color><param>1313,0000,FFFF</param><x-tad-bigger>NUVIO
CORPORATION</x-tad-bigger></color></fontfamily></bold><fontfamily><param>Arial</param><x-tad-bigger>

Phone: 816-444-4422 ext. 6757

Fax: 913-498-1810

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>http://www.nuvio.com</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>bmiller@nuvio.com</x-tad-bigger></color></fontfamily>
--Apple-Mail-7-543671811--