From: Michael Fuhr <mike@fuhr.org>
To: Henry Ortega <juandelacruz@gmail.com>
Cc: Owen Jacobson <ojacobson@osl.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Given 02-01-2006 to 02-28-2006, output all days.
Date: Sun, 19 Feb 2006 12:07:13 -0700
Message-ID: <20060219190713.GA43760@winnie.fuhr.org> (raw)
In-Reply-To: <2bffcc330602191047w6338e67aw77145989046f93d6@mail.gmail.com>
References: <144D12D7DD4EC04F99241498BB4EEDCC220D78@nelson.osl.com>
<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
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: mike@fuhr.org, juandelacruz@gmail.com, ojacobson@osl.com
Subject: Re: Given 02-01-2006 to 02-28-2006, output all days.
In-Reply-To: <20060219190713.GA43760@winnie.fuhr.org>
* 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