how to test my stored procedures?

From: "Yavuz Kavus" <yavuzkavus(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to test my stored procedures?
Date: 2006-06-15 03:07:18
Message-ID: 95b926fc0606142007v63cce78gae13b3fec073a83f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Qingqing Zhou 2006-06-15 03:12:49 Re: Out of memory error in 8.1.0 Win32
Previous Message Linux Portal 2006-06-15 02:18:44 How to optimize PostgreSQL database size