Date: Sun, 19 Feb 2006 12:07:13 -0700
From: Michael Fuhr <mike@fuhr.org>
To: Henry Ortega <juandelacruz@gmail.com>
Cc: Owen Jacobson <ojacobson@osl.com>, pgsql-sql@postgresql.org
Subject: Re: Given 02-01-2006 to 02-28-2006, output all days.
Message-ID: <20060219190713.GA43760@winnie.fuhr.org>
References: <144D12D7DD4EC04F99241498BB4EEDCC220D78@nelson.osl.com>
	<2bffcc330602191047w6338e67aw77145989046f93d6@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <2bffcc330602191047w6338e67aw77145989046f93d6@mail.gmail.com>

On Sun, Feb 19, 2006 at 01:47:21PM -0500, Henry Ortega wrote:
> I was able to find a suitable 7.3.2 plpgsql.so and now plpgsql works.
> (supposedly)
> 
> I am trying out some really basic function creation such as this:
> 
> create function dng2(start_date DATE) returns setof date as $$
> declare
> aa date:=start_date;
> 
> But I always get this
> ERROR:  parser: parse error at or near "DATE" at character 33
> before I can even finish.

You're using features (named parameters, dollar quotes) that are
available only in 8.0 and later; see the 7.3 documentation for the
correct syntax in that version.  But as someone else mentioned, do
consider upgrading, if not to 8.1.3 or 8.0.7 then at least to 7.3.14.
Lots of bugs have been fixed in the three years since 7.3.2 was
released, some involving data loss.

-- 
Michael Fuhr