X-Original-To: pgsql-sql@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 235DA474E53 for ; Mon, 17 Mar 2003 14:48:33 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2HJmXub007883; Mon, 17 Mar 2003 14:48:33 -0500 (EST) To: "David Witham" Cc: pgsql-sql@postgresql.org Subject: Re: parse error when calling function in plpgsql In-reply-to: References: Comments: In-reply-to "David Witham" message dated "Fri, 14 Mar 2003 20:18:42 +1100" Date: Mon, 17 Mar 2003 14:48:33 -0500 Message-ID: <7882.1047930513@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/413 X-Sequence-Number: 12452 "David Witham" 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