Adrian Klaver wrote:
>
>
> If you are using Postgres 8.1+ then it becomes even easier because you can use OUT parameters in the function
argumentlist to eliminate the "as test(c1 int,c2 int)" clause. At this point it becomes a A-->B-->C problem i.e
determinewhat your inputs are, how you want to process them and how you want to return the output.
>
'8.1+'?? Hmmm, I'm using 8.3. I could use that.
I got the more complex version of the query to work
by backing away from 'plpgsql' as the language and using
'sql' instead.
I then nested (terribly ugly) my select statements to
generate a single SQL query from all. This allows
me to change the output of the query without needing
to define a new set of output 'OUT' parameters each time
I change things.
I have use of the 'OUT' parameters with another set
of functions though. Thanks for that.
Peter