The following bug has been logged online:
Bug reference: 2230
Logged by: Murat Tasan
Email address: murat(dot)tasan(at)cwru(dot)edu
PostgreSQL version: 8.1.2
Operating system: Mac OS 10.4.4
Description: cannot return a setof column referenced types
Details:
Hi, I already heard from Tom Lane that this is a grammar oversight, and I
suspect it is a fairly easy fix... but to be somewhat formal I figured I'll
go ahead and fill the report:
During function creation, one cannot combine both SETOF and %TYPE.
For example:
CREATE FUNCTION temp_function() RETURNS SETOF table.column%TYPE AS %%
function_definition_here %% LANGUAGE SQL;
fails.
FYI.
Cheers!
Murat