Re: plpgsql For SQLQuery Loop Flags Error

Puneet Paul <paulptech(at)yahoo(dot)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