From: Bradley Miller <bmiller@nuvio.com>
To: pgsql-sql@postgresql.org
Subject: Recursive query to be used in another result ?
Date: Wed, 12 Jan 2005 11:53:26 -0600
Message-ID: <DC7E60F8-64C2-11D9-BEEF-000D932ED682@nuvio.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bmiller@nuvio.com
Subject: Re: Recursive query to be used in another result ?
In-Reply-To: <DC7E60F8-64C2-11D9-BEEF-000D932ED682@nuvio.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox