[ MarkoBalkan @ 07.08.2009. 22:28 ] @
imam proceduru Code: 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. |