Re: Loop in loop - Mailing list pgsql-general

OK, this looks better:


CREATE OR REPLACE FUNCTION getregistrationtagging()
  RETURNS SETOF ty_usertracking AS
$BODY$
DECLARE objReturn ty_usertracking%rowtype;
BEGIN
        for objReturn IN
        SELECT     date_part('day',trackdate) as ty_day,
            date_part('month',trackdate) as ty_month,
            date_part('year',trackdate) as ty_year,
            tag as ty_tag,
            designid as ty_designid
        FROM tbl_usertracking_registration
        GROUP BY     date_part('day',trackdate),
                date_part('month',trackdate),
                date_part('year',trackdate),
                tag,
                designid
           loop
               SELECT INTO objReturn.ty_count count(*) FROM tbl_usertracking_registration
                    WHERE date_part('day',trackdate)=objReturn.ty_day
                    AND date_part('month',trackdate)= objReturn.ty_month
                    AND date_part('year',trackdate)=objReturn.ty_year
                    AND tag=objReturn.ty_tag
                    AND designid=objReturn.ty_designid;
                       SELECT INTO objReturn.ty_date max(trackdate) FROM tbl_usertracking_registration
                    WHERE date_part('day',trackdate)=objReturn.ty_day
                    AND date_part('month',trackdate)=objReturn.ty_month
                    AND date_part('year',trackdate)=objReturn.ty_year
                    AND tag=objReturn.ty_tag
                    AND designid=objReturn.ty_designid;

            return next objReturn;   
     END LOOP;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION getregistrationtagging() OWNER TO postgres;

But still the question:
Is it possible to put a loop into a loop?  Or doesn't it make sense at all?

Kind regards,
Mo