Untyped result (setof / rowset) from Functions ? - Mailing list pgsql-general

From Modern Mexican
Subject Untyped result (setof / rowset) from Functions ?
Date
Msg-id MPBBJNBFMGDOEMEFADNECEOLBGAB.felipe@modernmexican.com
Whole thread Raw
Responses Re: Untyped result (setof / rowset) from Functions ?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Is there a technical reason why an untyped result (setof / rowset) from a
function (sql or plpgsql) is not implemented ?

Something Simple:

CREATE FUNCTION foo(x int) RETURNS SETOF records AS
'SELECT t1.*, t2.* FROM t1 INNER JOIN t2 ON t1.a=t2a
WHERE WHERE t1.id=$1'
LANGUAGE SQL

So I will not have to create a TYPE every time I return a SETOF JOINED
tables or a sub-set of the columns of a table.

Thanks.



pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: query execution
Next
From: Matthew Peter
Date:
Subject: transaction toggling