| From: | Bradley Miller <bmiller(at)nuvio(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Recursive query to be used in another result ? |
| Date: | 2005-01-12 17:53:26 |
| Message-ID: | DC7E60F8-64C2-11D9-BEEF-000D932ED682@nuvio.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)nuvio(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kieran Ashley | 2005-01-12 18:08:41 | Problems with Quotes |
| Previous Message | Michael Fuhr | 2005-01-12 17:41:30 | Re: Problems with HAVING |