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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: using sql on v7.4 server to feed stored procedure
Дата
Msg-id 23120.1175285688@sss.pgh.pa.us
обсуждение исходный текст
Ответ на using sql on v7.4 server to feed stored procedure  ("Brian Jarrett" <digimotif@gmail.com>)
Список pgsql-sql
"Brian Jarrett" <digimotif@gmail.com> 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Brian Jarrett"
Дата:
Сообщение: using sql on v7.4 server to feed stored procedure
Следующее
От: Karthikeyan Sundaram
Дата:
Сообщение: function return array