Date: Tue, 18 Jan 2005 23:39:19 -0700
From: Michael Fuhr <mike@fuhr.org>
To: Bradley Miller <bmiller@nuvio.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: URGENT:  Using function inside query
Message-ID: <20050119063918.GA57167@winnie.fuhr.org>
References: <A94BADA0-6992-11D9-BEEF-000D932ED682@nuvio.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <A94BADA0-6992-11D9-BEEF-000D932ED682@nuvio.com>

On Tue, Jan 18, 2005 at 02:51:01PM -0600, Bradley Miller wrote:

> select account_id from roll_account(1186) where hierarchy_type_id = 2 
> 
> The problem is I have data like this: 
> 
> account id    name     
> 
> 1    Company A   
> 2    Company B 
> 3    Company C 
> 4    Person 1 (in Company A) 
> 5    Person 2 (in Company A) 
> 
> If I pass it the number of let's say Person 2 -- the above query wold 
> give me the account id of 1.    How can I do a query using that 
> function so that it automatically inserts the account_id to show the 
> "rolled up" account id ?  

I'm not sure I follow -- what account_id are you trying to insert
and where are you trying to insert it?  Do you want something like
this?

SELECT account_id
FROM roll_account(
  (SELECT account_id FROM account_info WHERE name = 'Person 2')
)
WHERE hierarchy_type_id = 2;

If that's not what you're after then please provide an example of
the kind of query you'd like to make and what results you expect.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/