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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
