CREATE OR REPLACE FUNCTION marko1()
RETURNS setof record AS
$BODY$
select * from prva,druga where prva."Id"=druga."Id_prva"
$BODY$
LANGUAGE 'sql';
i ova procedura mi vrati x slogova ali sa jednim poljem.
što staviti umjesto record da mi vraća slogove sa poljima.
npr.
select marko1()
vrati
marko1
record
(1,1,1,2,3)
a kada probam
select * from marko1
naravno javi grešku
ERROR: a column definition list is required for functions returning "record"
LINE 1: select * from marko1()
^
********** Error **********
ERROR: a column definition list is required for functions returning "record"
SQL state: 42601
Character: 16
ako imam jednu tableu sve funkcionira.