"Brian Jarrett" <[EMAIL PROTECTED]> writes: > The following statement works on 8.x servers, but not on 7.4 and I > can't figure out how to get it to operate in the earlier version:
> select calc_cum_gpa_mp(marking_period_id::TEXT) > from (select distinct marking_period_id from student_mp_stats) as > sms1; > I get the error: > ERROR: syntax error at or near "(" > SQL state: 42601 > Context: compile of PL/pgSQL function "calc_cum_gpa_mp" near line 8 > Can anyone point me in the right direction? You need to look into the referenced plpgsql function; this statement in itself is not at fault. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly