Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7C3FA4761E8 for ; Tue, 8 Oct 2002 04:44:49 -0400 (EDT) Received: from anchor-post-39.mail.demon.net (anchor-post-39.mail.demon.net [194.217.242.80]) by postgresql.org (Postfix) with ESMTP id 84B8D475F80 for ; Tue, 8 Oct 2002 04:44:46 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-39.mail.demon.net with esmtp (Exim 3.36 #2) id 17ypyx-00073k-0U; Tue, 08 Oct 2002 09:44:47 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 97A7E16F12; Tue, 8 Oct 2002 09:32:57 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 101F416F11; Tue, 8 Oct 2002 09:32:57 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: gordoncl@optusnet.com.au, pgsql-sql@postgresql.org Subject: Re: Probs "compiling" a function Date: Tue, 8 Oct 2002 09:32:42 +0100 User-Agent: KMail/1.4.3 References: <200210080214.g982EAt24326@mail019.syd.optusnet.com.au> In-Reply-To: <200210080214.g982EAt24326@mail019.syd.optusnet.com.au> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200210080932.42532.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/103 X-Sequence-Number: 9821 On Tuesday 08 Oct 2002 3:14 am, gordoncl@optusnet.com.au wrote: > Greetings, Having probs just "compiling" this fn and it comes back with a > very stark error msg which is below. I'm using version 7.1.3 > > I run the script as: > \i procedures/zff > > and get the error msg: > psql:procedures/zff:51: ERROR: parser: parse error at or near "b" > > Line 51 is the line that starts LANGUAGE.... ... > VALUES(upper($1),$2,upper($3),upper($4),$5,$6,$7,$8,$9,upper($10),$11, > $12,$13,$14,/'B/',t_class_sun,$16); I think the 'B' here might be the problem - did you mean \'B\' or ''B''? It probably doesn't spot it until the end of the definition when it hits=20 another quote on the "language" line. - Richard Huxton