how to test my stored procedures? - Mailing list pgsql-general

From Yavuz Kavus
Subject how to test my stored procedures?
Date
Msg-id 95b926fc0606142007v63cce78gae13b3fec073a83f@mail.gmail.com
Whole thread Raw
Responses Re: how to test my stored procedures?
Re: how to test my stored procedures?
List pgsql-general
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.
 
i want to test from a query tool.
i can do with procedures without out paramters,
but how to achive with out parameters?
can i declare a variable out of procedure and
then send it as an out parameter and see it is value?
 
thanks for your help.

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: tsearch2
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Out of memory error in 8.1.0 Win32