Re: 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".

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