From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Witham <davidw@unidial.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: parse error when calling function in plpgsql
Date: Mon, 17 Mar 2003 14:48:33 -0500
Message-ID: <7882.1047930513@sss.pgh.pa.us> (raw)
In-Reply-To: <CFA248776934FD43847E740E43C346D1379668@ozimelb03.ozicom.com>
References: <CFA248776934FD43847E740E43C346D1379668@ozimelb03.ozicom.com>
"David Witham" <davidw@unidial.com.au> writes:
> myrec record;
> ...
> select * into myrec from myfunc(...params...) as (col1 real,col2 integer);
> but I keep getting a parse error:
> WARNING: Error occurred while executing PL/pgSQL function myparentfunc
> WARNING: line 27 at select into variables
> ERROR: parser: parse error at or near "$1" at character 72
I doubt this has anything to do with the function per se. I'd check for
a conflict between the names you are using as plpgsql variables and the
names mentioned in this SELECT.
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, davidw@unidial.com.au
Subject: Re: parse error when calling function in plpgsql
In-Reply-To: <7882.1047930513@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