Yavuz Kavus wrote:
> hi everybody.
>
> i am writing stored procedures.
> lots of them have out parameters.
>
> i dont know how to test them
> from an sql query tool(ex: pgAdmin query tool).
> i am trying to test them from my program, but it is not so efficient.
OUT parameters get returned as part of a record.
CREATE FUNCTION foo(a int4, OUT b int4, OUT c int4) AS $$
BEGIN
b:=a+1;
c:=a+2;
END; $$ LANGUAGE plpgsql;
richardh=# SELECT foo(9);
foo
---------
(10,11)
HTH
--
Richard Huxton
Archonet Ltd