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: | Raw Message | Whole Thread | 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? |