X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 87E11476237 for ; Thu, 3 Apr 2003 14:54:03 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id D1F16475ED4 for ; Thu, 3 Apr 2003 14:54:02 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 191B3C-0005Uc-00 for ; Thu, 03 Apr 2003 13:11:06 -0700 Date: Thu, 3 Apr 2003 13:10:41 -0700 From: Roberto Mello To: Josh Berkus Subject: Re: pesky plpgsql Message-ID: <20030403201041.GD19784@cc.usu.edu> References: <200304031001.36024.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <200304031001.36024.josh@agliodbs.com> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. Resent-From: rmello@cc.usu.edu Resent-Date: Thu, 3 Apr 2003 13:11:06 -0700 Resent-To: pgsql-sql@postgresql.org Resent-Message-Id: Resent-Sender: Roberto Mello X-Spam-Status: No, hits=-34.8 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/49 X-Sequence-Number: 12750 On Thu, Apr 03, 2003 at 10:01:36AM -0800, Josh Berkus wrote: > Walter, > > > CREATE FUNCTION update_cat_keys() RETURNS integer AS ' > > declare > > v_row RECORD; > > What's in-between v_row and RECORD? Maybe a non-standard tab character? "non-standard tab character"? Are you saying tab is non-standard or that there's some sort of weird tab character that could be being used in this case? I've always used tabs in my PL/pgSQL functions and it works just fine. -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + A poor excuse is better than no excuse!