Обсуждение: How to run a procedure

Hi all

I'm new developing procedures in PL/PGSQL. I'm using Query Tool as code
editor, but execute query button only mark sintax errors and I want to run
my application.

How can I test my function?

Thanks!
--
View this message in context: http://www.nabble.com/How-to-run-a-procedure-tp22606191p22606191.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

hello

2009/3/19 jc_mich <juan.michaca@paasel.com>:
>
> Hi all
>
> I'm new developing procedures in PL/PGSQL. I'm using Query Tool as code
> editor, but execute query button only mark sintax errors and I want to run
> my application.
>
> How can I test my function?
>

write
select nameofyourfunctions(parameters);

regards
Pavel Stehule

> Thanks!
> --
> View this message in context: http://www.nabble.com/How-to-run-a-procedure-tp22606191p22606191.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

On Thu, Mar 19, 2009 at 12:11 PM, jc_mich <juan.michaca@paasel.com> wrote:
>
> Hi all
>
> I'm new developing procedures in PL/PGSQL. I'm using Query Tool as code
> editor, but execute query button only mark sintax errors and I want to run
> my application.

select myfunction(arg1, arg2);