Re: [GENERAL] calling a stored procedure using sql query in 7.4

2007-04-02 Thread Alban Hertroys
BaseTwo wrote: > 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 err

[GENERAL] calling a stored procedure using sql query in 7.4

2007-04-02 Thread BaseTwo
I've created some sql scripts to update a database in version 8.x and now I'm trying to get them to run on servers using v7.4 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_