From: Richard Huxton <dev@archonet.com>
To: gordoncl@optusnet.com.au
To: pgsql-sql@postgresql.org
Subject: Re: Probs "compiling" a function
Date: Tue, 8 Oct 2002 09:32:42 +0100
Message-ID: <200210080932.42532.dev@archonet.com> (raw)
In-Reply-To: <200210080214.g982EAt24326@mail019.syd.optusnet.com.au>
References: <200210080214.g982EAt24326@mail019.syd.optusnet.com.au>
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
another quote on the "language" line.
- Richard Huxton
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: dev@archonet.com, gordoncl@optusnet.com.au
Subject: Re: Probs "compiling" a function
In-Reply-To: <200210080932.42532.dev@archonet.com>
* 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