Hi *
I need to write a function, that returns a set of all columns from 2
tables.
e.g. I create such a function:
CREATE OR REPLACE FUNCTION func(val_ int8)
RETURNS SETOF record AS
$BODY$
DECLARE
i record;
BEGIN
for i in select * from "Table1", "Table2"
loop
return next i;
end loop;
return;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION func(val_ int8) OWNER TO postgres;
But when I try to call it like this:
SELECT * FROM func1(10);
I have an error:
ERROR: a column definition list is required for functions returning
"record"
This two tables have about 20 columns together, so I don't want list
them each I call this function. Can I achieve this in some other
(right) way?
P.S. I don't want to create a specific type for this purpose, but
if there is no other way, I should.
Thanks in advance.
--
Best regards,
Dmitriy Chumack mailto:saint.d.a@gmail.com