X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 08CB5474E42 for ; Thu, 3 Apr 2003 20:11:00 -0500 (EST) Received: from mars-hq (dsl231-057-057.sea1.dsl.speakeasy.net [216.231.57.57]) by postgresql.org (Postfix) with SMTP id 78820474E42 for ; Thu, 3 Apr 2003 20:10:27 -0500 (EST) Received: (qmail 7673 invoked from network); 3 Apr 2003 18:29:14 -0000 Received: from unknown (HELO mars-hq.com) (10.0.0.3) by dsl231-057-057.sea1.dsl.speakeasy.net with SMTP; 3 Apr 2003 18:29:14 -0000 Date: Thu, 3 Apr 2003 17:10:41 -0800 Subject: Re: pesky plpgsql Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v551) From: Walter McGinnis To: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit In-Reply-To: <200304031200.24592.josh@agliodbs.com> Message-Id: <40DF58C4-663A-11D7-AEDC-00306571D2C4@mars-hq.com> X-Mailer: Apple Mail (2.551) X-Spam-Status: No, hits=-28.3 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REPLY_WITH_QUOTES,USER_AGENT_APPLEMAIL 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/59 X-Sequence-Number: 12760 Well I discovered on my own that it was the tabs that were causing the problem. Which is pretty strange considering I was using emacs on a remote BSD machine. Walter On Thursday, April 3, 2003, at 12:00 PM, Josh Berkus wrote: > Roberto, > >> "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. > > Yes, but some older DOS or other editors, or graphical word > processors, use a > tab which is *not* the standard ASCII character, or an end of line > marker > which is not CR or CRLF. For example, try creating a PL/pgSQL > function > using MS WORD 2000 .... > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html