Re: plpgsql For SQLQuery Loop Flags Error

Puneet Paul <paulptech@yahoo.com> writes:
>  DECLARE
>      curTrackList char(15) ALIAS for $1;
>     sliceFile varchar ALIAS for $2;
>     lmfpLimit integer ALIAS for $3
>     mTrackDet RECORD;

If that's an accurate copy of your function, then the problem is likely
the lack of a semicolon on the lmfpLimit line.  I'm not sure why you
don't get a syntax error, but evidently the "mTrackDet RECORD" is
getting treated as a noise phrase in the lmfpLimit declaration.

What Postgres version is this, anyway?  The current sources do not look
like they'd accept such a thing without raising an error, but possibly
older releases would.

            regards, tom lane