Re: Execute a function? - Mailing list pgadmin-support

From Sim Zacks
Subject Re: Execute a function?
Date
Msg-id 342055250.20050315081620@compulab.co.il
Whole thread Raw
In response to Re: Execute a function?  ("Steve - DND" <postgres@digitalnothing.com>)
List pgadmin-support
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



pgadmin-support by date:

Previous
From: "Steve - DND"
Date:
Subject: Re: Execute a function?
Next
From: "Dave Page"
Date:
Subject: Re: Execute a function?