Thread: for looping

Does FOR LOOP work on SELECT?  The following simple function looks good to
me but does not compile because of "missing .. at end of SQL expression".


CREATE FUNCTION get_all_diffs()
RETURNS FLOAT AS '
DECLARE
 i INTEGER := 0;
sym_diff FLOAT := 0.0;

BEGIN
 FOR row IN SELECT * FROM "tblTrades" LOOP
  i := i+1;
 END LOOP;

 RETURN sym_diff;
END;'

LANGUAGE 'plpgsql'
;

SELECT get_all_diffs();

> Does FOR LOOP work on SELECT?  The following simple function looks good to
> me but does not compile because of "missing .. at end of SQL expression".

you need to the declare the row record

DECLARE
    row RECORD;
BEGIN

>
> CREATE FUNCTION get_all_diffs()
> RETURNS FLOAT AS '
> DECLARE
>  i INTEGER := 0;
> sym_diff FLOAT := 0.0;
>
> BEGIN
>  FOR row IN SELECT * FROM "tblTrades" LOOP
>   i := i+1;
>  END LOOP;
>
>  RETURN sym_diff;
> END;'
>
> LANGUAGE 'plpgsql'
> ;
>
> SELECT get_all_diffs();
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

Mike