Re: how to test my stored procedures?

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.
>
> 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.

I test mine from the query editor.

PG Lightning Admin also has a nice function editor that has a run
button, the run button will then prompt you for any input params that
need values, then create the sql for you to run in the query editor.

Of course you can do this manually.

If your function has out params call it from the query editor just like
you would call a table.

select * from myproc();

You can then see the results.

--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com