Re: [SQL] using sql on v7.4 server to feed stored procedure

2007-03-30 Thread Tom Lane
"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

[SQL] using sql on v7.4 server to feed stored procedure

2007-03-30 Thread Brian Jarrett
I just found out that I posted this to the wrong list before, so if this ends up as a cross-post, I'm sorry. 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