Query con campos dinámicos

[seyko]

Buenas, se hace asi:

CREATE OR REPLACE FUNCTION dinamica(campo varchar) RETURNS SETOF record
AS
$BODY$
DECLARE
r record;
BEGIN
for r in EXECUTE 'select ' || campo || ' as c from tb_x
loop
return next r;
end loop;

END;
$BODY$ LANGUAGE 'plpgsql' VOLATILE;


select * from dinamica('id') as foo(id integer)

Un saludo