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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
