Re: Syntax error, but where? - Mailing list pgsql-general

From Bricklen Anderson
Subject Re: Syntax error, but where?
Date
Msg-id 440C5CA7.8060003@presinet.com
Whole thread Raw
In response to Syntax error, but where?  (Michael Trausch <michael.trausch@comcast.nope.net>)
Responses Re: Syntax error, but where?  (Michael Trausch <michael.trausch@comcast.nope.net>)
List pgsql-general
Michael Trausch wrote:
> Hey guys,
>
> I'm having a slight problem with this database that I'm trying to setup
> on PostgreSQL 8.1.3... What I've got is a stored procedure that refuses
> to get itself into the system, and I'm not sure why.  It is throwing a
> syntax error on DECLARE, but I don't see it.  I looked at the
> documentation, and as far as I can tell, my CREATE FUNCTION line looks
> just as it should in structure, as does the CREATE TYPE line that is
> immediately before it.
>
> Any ideas?
>
> The code that is failing is:
>
> ================
>
> CREATE TYPE app_global.city_list AS (zip_code CHAR(5), city_name
> VARCHAR(40), state_abbr CHAR(2), distance_miles NUMERIC(6,3));
>
> --
> -- Stored Procedures in app_global
> --
>
> CREATE FUNCTION app_global.get_zip_codes_range(zip_code CHAR(5),
> range_miles NUMERIC(4,1)) RETURNS SETOF city_list AS $$FUNC_BODY$$

Is this actually part of the function: $$FUNC_BODY$$ ?
If so, try it as $FUNC_BODY$ (single dollar signs around identifier).

pgsql-general by date:

Previous
From: Emil Rachovsky
Date:
Subject: Syntax error in Execute statement
Next
From: "Florian G. Pflug"
Date:
Subject: Re: [OFFTOPIC] Typo3 + Postgresql anyone?