| From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
|---|---|
| To: | Steve - DND <postgres(at)digitalnothing(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Execute a function? |
| Date: | 2005-03-15 06:16:20 |
| Message-ID: | 342055250.20050315081620@compulab.co.il |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2005-03-15 08:17:54 | Re: Execute a function? |
| Previous Message | Steve - DND | 2005-03-15 05:55:24 | Re: Execute a function? |