From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brian Jarrett <digimotif@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: using sql on v7.4 server to feed stored procedure
Date: Fri, 30 Mar 2007 16:14:48 -0400
Message-ID: <23120.1175285688@sss.pgh.pa.us> (raw)
In-Reply-To: <68b897d90703301219p5a891976wf3f0baefc5f85551@mail.gmail.com>
References: <68b897d90703301219p5a891976wf3f0baefc5f85551@mail.gmail.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, digimotif@gmail.com
Subject: Re: using sql on v7.4 server to feed stored procedure
In-Reply-To: <23120.1175285688@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox