On Thursday 15 January 2004 15:02, Bill Moran wrote:
> I'm having a little trouble understanding how to do something. I assume
> I'm just missing it in the documentation, so a pointer to relevent docs
> would be as welcome as a direct answer.
>
> I have a project in which I'll need to create a number of stored procedures
> that are basically wrappers around complex SQL statements. Along the lines
> of:
...
> I keep getting these errors:
> ERROR: return type mismatch in function declared to return integer
> DETAIL: Final SELECT must return exactly one column.
> CONTEXT: SQL function "expired" during startup
Try SETOF subscription for this example - you're not telling it the type of
the result (which in your example is a row from subscription).
--
Richard Huxton
Archonet Ltd