Stored procedure returning row or resultset

Hello,

I'm trying to achieve the following with pl/pgsql in postgres 7.2:

I need a stored procedure proc() that calculates values for some fields
a = f1()
b = a + f2()
c = b + f3()
and returns the tuple (a,b,c) as a rowtype,

so that "select proc()" produces a "normal" resultset that can be used in an 
application.


I know of course that I could write out
SELECT
(f1()) AS a
(f1() + f()) AS b
(f1() + f2() + f3()) AS c ...
in plain SQL and create a view on that, but the problem is that f1(), f2(), 
f3() are complex and expensive computations that I want to run only once. In 
the example I would call f1() three times, which is inacceptable.

Is there a way to accomplish this? I have tried around quite a bit, but I 
cannot find out the correct syntax .

Thank you,
Heiko Stoermer

-- 
Heiko Stoermer
Diplom-Informatiker (FH)             Login & Solutions AG
Tel.: +49-821-2488-0                 http://www.login-solutions.de