CREATE OR REPLACE FUNCTION public.view_foto(int4)
  RETURNS text[] AS ' 
    DECLARE 
        foto_id_ ALIAS FOR $1; 
        res text[]:=\'{}\';
	cid1_ integer;
	cid2_ integer;
	cid3_ integer;
	name_ text;
	foto_type_ text;
	keywords_ text;
	description_ text;
	date_ text;
	views_ integer;
	mark_ integer;
	sum_mark_ integer:=0;
	i integer:=0;
	row_data comments%ROWTYPE;
    BEGIN 
        select category_id_1,category_id_2,category_id_3,name,foto_type,keywords,description,date,views from foto where id=foto_id_ into cid1_,cid2_,cid3_,name_,foto_type_,keywords_,description_,date_,views_;
	res[0]:=cid1_;
	res[1]:=cid2_;
	res[2]:=cid3_;
	res[3]:=name_;
	res[4]:=foto_type_;
	res[5]:=keywords_;
	res[6]:=description_;
	res[7]:=date_;
	res[8]:=views_;
	FOR row_mark IN SELECT * FROM comments WHERE foto_id=foto_id_ LOOP
		i:=i+1;
		sum_mark_:=sum_mark_+row_mark.mark;
	END LOOP;
	RETURN res; 
    END; 
'
  LANGUAGE 'plpgsql';