Обсуждение: Execute a function?

I'm completely baffled here. I've created a function, but how can I execute
it? I tried opening up the SQL editor window and typed:

test_function(20, 32);
received: ERROR:  syntax error at or near "test_function" at character 1

I then tried:
EXECUTE my_function(20, 32);
received: ERROR:  prepared statement "test_function" does not exist

What the heck do I have to do to execute my functions to see the results of
them? The function exists, it shows up in the list of functions for the DB.
This seems so stupidly simple, and it probably is, so what am I doing wrong?

Thanks,
Steve

On Monday 14 March 2005 21:31, you wrote:
> I'm completely baffled here. I've created a function, but how can I execute
> it? I tried opening up the SQL editor window and typed:
>
> test_function(20, 32);
> received: ERROR:  syntax error at or near "test_function" at character 1
>
> I then tried:
> EXECUTE my_function(20, 32);
> received: ERROR:  prepared statement "test_function" does not exist
>
> What the heck do I have to do to execute my functions to see the results of
> them? The function exists, it shows up in the list of functions for the DB.
> This seems so stupidly simple, and it probably is, so what am I doing
> wrong?
>
> Thanks,
> Steve
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Been a _very_long while, but try:

SELECT my_function(param_1, param_2) As Answer;
--
Mark A. Taff

> Been a _very_long while, but try:
>
> SELECT my_function(param_1, param_2) As Answer;

Yep, that did it. I'm such a newb with PG, still trying everything the MSSQL
way first. Is that the proper way to do it even if you have a function that
returns void?

Steve

If you have a function that returns a recordset instead of just a
value then you would have to do a select * from functionname
You can also try reading the documentation on functions. I believe
section 35 discusses the various pl languages.

Sim
__________________________________________________________

> Been a _very_long while, but try:
>
> SELECT my_function(param_1, param_2) As Answer;

Yep, that did it. I'm such a newb with PG, still trying everything the MSSQL
way first. Is that the proper way to do it even if you have a function that
returns void?

Steve



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faq

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Steve - DND
> Sent: 15 March 2005 05:55
> To: Mark A. Taff; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Execute a function?
>
> > Been a _very_long while, but try:
> >
> > SELECT my_function(param_1, param_2) As Answer;
>
> Yep, that did it. I'm such a newb with PG, still trying
> everything the MSSQL
> way first. Is that the proper way to do it even if you have a
> function that
> returns void?

Yeah, though you'd omit the 'As Answer' (which will fold to lower case
without quotes btw). That bit just gives the resulting column an alias.

Regards, Dave